Don't know if I should have said "gray" or "grey", but my "undo button"
remains grayed out even though I'm entering data in and selecting cells.
There is also no "Redo" button.  Is there some setting for this that I'm
unaware of?

=IF(OR(ISBLANK(A1),A1=0),"",NOW())
I am using this formula in B1 to record the date when  cell A1 has been
updated. Problem is the date is always updating to the current date. How can
I change it so it show when the cell was updated?

hi group,
re: xl2k
I have a multi-sheet (3-D) range name specifying
(the same) column for all my sheets:

Excel 2002 SP3
Win XP Pro SP2
I need to copy a sheet inside a workbook, to many other workbooks.
One of the problems is that each of the workbooks contains ranges named

I'm playing in a new workbook, which has not been saved. On the first 3
worksheets, I'm just playing with simple formulas. I insert a new worksheet.
With A1 selected I attempt to insert a new column and get the message:
Cannot shift objects off sheet. I get the same message if I ...

I have been trying to import contacts from an excel spreadsheet to Outlook
and my attemps have been unsuccessful. I really would appreciate any help or
tips on how to manage this operation. thanking you in advance.

I use the addin to transfer records directly to a worksheet.
Is there anyway to automate this procedure?
Currently my macros will set up a sheet and advise the user of  the directory where the DTF is
stored.

I am on line 28 of my worksheet and , all of a sudden, I keep getting a
message saying :...excel cannot shift nonblank cells off worksheet...I am new
to PC use, so please  don't answer in computerese. Thanks

I am preparing my invoices in Excel 2003 for my customers, so when I use the
auto sum option for having the total, I need to type the total amount in
words before issuing the invoice to my customers. So I kindly request to
solve this serious issue by giving me an simple example or ...

I am running excel 2002 on windows xp professional.  I have an excel
file and I am trying to create a hyperlink to a file on the network.
After I create the hyperlink I can click on it and it will open the
file.  After I save the excel file it will not work any more.  Any

I'm using Excel 2004 in Mac OS X Tiger. I use dates in dd/mm/yy
format, and that's how it is set in my international preferences panel
(in Tiger) and how i formated the Excel column.
but then i type, say, 4/11/07 (to enter the date 4th nov 07) and excel

Hi all! I have the following little code that processes the series in
the active chart:
Sub RemoveOldSeriesInActiveChart()
   ActiveChart.SeriesCollection(12).Delete

Thanks for looking at this:
I want to list a number of names on sheet one of a workbook and I want
to be able to click on a name and it take me to another worksheet, in
the same workbook which is linked to that name.

I have in A column hundreds of dates. B column has hudreds of names.
A                    B
11.01.2008    Tim
12.01.2008    Paul

I have a worksheet with numerous subtotals and a grandtotal. The subtotals
are separated by several individual entries for each subtotal. I have tried
selecting each subtotal and the grand total cell, but when I hit enter it
shows only the last subtotal. What am I doing wrong?