I want to name a range of cells with the name 3YEAR but it will not allow a
number to start the name. Is there a way around this?
Thanks in advance of any help.
John

Okay, I'm at it again, but only with further testing on this defined names
issue.  I have seen different posts stating that with excessive number of
range names, it causes the files to process significantly slower, which I
have seen no such symptom within my own files.  However, ...

Let's say I'm referencing cell A2 and am calling it myRange.  How do I find
out the other cells that are merged with A2 programmatically?
Thanks in advance,
Barb Reinhardt

hi, first of all thanks for looking at this and helping me
hopefully :)
i'm setting up a new rota system on excel for work, but it's using
windows me and excel 2000 :(

Here's the Macro:
Sub DeleteBlanksInColumnA()
'
' Macro1 Macro

I have a workbook with a few sheets on it.   One sheet is mostly a page to
enter data.  I have a macro that if the cell isn't blank and you edit or
delete it. It prompts and r u sure message.  only if you select multiple
cells then it gives an error/debug message.  Here is my ...

I have a macro which is used in a sheet used to draw diagrams. The user
clicks on the shape which is then copied, enlarged and pasted a few cells to
the right.
The problem I am having is that the macro is still assigned to the pasted

I have the following code which works fine when I import information into a
spreadsheet on my PC but which creates run time errors when replacing Overall
Result with ""  when used by someone else. I think we are working on
different versions of Excel.  Is there some modification ...

Howdy, Excel gurus!
I have two sheets I want to compare.  My first sheet "Working Copy"
has a column "DUNSNumber" (column M) and I have a sheet "Wash List"
that has a list of DUNSNumber values on it as well (column B).  My

I know that I've read somewhere that there are some things UDF's cannot do.
Where can I find an explanation of those limitations?  Using Excel 2000, I'm
trying to change the numerical format of the calling cell.  Is this
possible?

Is there a way to hibernate a computer via Excel VBA?
I tried something like  SendKeys "^{ESC}u", True
to get the shutdown box up but it doesn't work.
Any other ideas?

I'm having trouble accessing a public variable in a module when this
public variable is declared in another module.  Here's my situation
where I have 2 forms and 2 modules:
form1

is there a way to save data that is entered into a sheet from a data base and
move to the next column each day new information is sent to the sheet. I want
to keep the information in the spicific column but save it then move to the
next colume for the next day automaticaly saving ...

I have a workbook with 26 paysheets, which includes the dates of a given pay
period.  I'd like a macro that will find the cells where a holiday occurs.  
Christmas was quite easy to do as it anyways appears in the last paysheet.  
Veteran's day, however, is more challenging because ...

I have  a macro that makes a copy of the workbook that it's associated with.
Is it possible to modify this macro so that the copy of the workbook is
devoid of macros?
Thank you in advance for your help.