Is there an Excel macro that simulates the effect of specifying the
rows and columns to repeat in a printout?  I am looking for something
that simulates the following operations:
1) Page Setup->Sheet [Tab]->Rows to repeat at Top

I use Excel a lot to extract data from tab delimited files.  I used to
export with it, and the "'s Excel inserts around each cell (puts it as first
character and last) which wasn't that much of a problem when the file was
small, but now I have over 600 lines of this.  It also ...

I have a computer in my classroom that has excel on it and everytime I type
a number, such as 30 it outputs .3.  The only thing I can find different
than the other computers in my classroom is that on the gray bar above the
system tray the word FIX shows up.  Normally I only have ...

How do I make a macro run automatically when a worksheet it is attached to is
loaded?

Can we have an empty cell but formula embedded in that cell.

Is it possible to have a reference date in Cell A1 - say 19/04/2005 and
Return a value in Cell B1 - Tuesday ?. I've tried =DAY(A1) but it returns 19
Thanks

Hi - I have a series of cells which have number in them. I add conditional
formats so that if the value in the cell is above certain thresholds the
cell is coloured red/amber/green (traffic light repoprts). The thing is when
the report is printed the numbers still show.

Can I display more than one curve (i.e., more than a single set of data
points) in a single chart?
I am using Excel 2000.
tia

When using outline, how do I show detail and hide detail
using VBA code?
Thank you.

I like to use F5 to locate columns.
I have migrated from MSWorks where a lot of my columns have
Cell reference numbers  eg FP1  FP2 etc
Do I have to rename all these column labels?

Good Morning Eveyrone,
Using Excel XP.  I would I write the formula =SMALL(A1:A100) that would find
the lowest numbers that are NOT zeros.
Thanks for you help,

In Excel 2003 on a Windows Server 2003 box, under Tools/Macros, all the
macro options except Security are greyed out. Neither Detect/Repair nor
Reinstall fix it. How can I activate these options?
GaryK

I am needing some help with getting a command button to run a query through
msquery onto a worksheet.  i have a work book with 33 worksheets.  the first
31 worksheets are setup to be 1 sheet for 1 day's data, worksheets are
labeled as 1,2,3,...30,31.  the last two of the 33 ...

I have the formula below that looks at a table of transactions, which show
stock movements by date by location. The formula shown gives me total
purchases for a Product Code that is detailed within H6, within the table
concerned for the location 'London'

I was wondering if I can set this up somehow.
If I type in a certain name of a product, would excel be able to
automatically put that price in a certain field on a regular basis.  It
would save me all kinds of time so I would not have to look at my price