Need list of Excel reserved words

[jacobskl]

Does anyone know where I can find a list of the Excel reserved words?

(PS: MrExcel: You looked really good on TV. Glad it went well!)

 

[Travis]

you mean a list of functions?
nothing is reserved unless you lead it with =

 

[jacobskl]

No, I mean a list of words that can't be used for named ranges. You know the ones that give the "use a different name" message.

 

[Travis]

Other than a few rules, I wasnt aware of any reserved

Must start with a letter or underscore
Canot be a cell reference
Canot have a space
Canot be more than 255 characters

If you have a word that meets these criteria and still insnt allowed, Id be interested to know what it is...Ive never come across one.

 

[Mark W.]

Some worksheets have hidden defined names. Is that the problem?

 

[jacobskl]

Thanks for the feedback Travis and Mark. I am checking with the person with the original problem to see if any of these ideas apply.

(IF there aren't any, that would explain why extensive searching by myself and others can't find a list online!)

 

[PaddyD]

Travis missed an option:

named ranges:

can start with a backslash, letter or underscore

...other than that, you cannot set up defined names that cause referential ambiguities (eg D1 is not an allowed name as it's also a cell reference).

 

[Mark O'Brien]

This is p***ing me off now. I remember reading that there were two really useful hidden and undocumented named ranges. I've checked OzGrid, j-walk and cpearson.com to try to find this. They weren't like other reserved names (e.g. Print_Area) because they never appeared in the name box.

Gah! I can only vaguely remember that the names began with "_".

Can anyone help my to remember?

 

[jacobskl]

Thanks for the updates guys. And, Mark, you aren't the only one. We seem to have all the best Excel people on the web looking and no one has the answer.

 

[Juan Pablo González]

This is p***ing me off now. I remember reading that there were two really useful hidden and undocumented named ranges. I've checked OzGrid, j-walk and cpearson.com to try to find this. They weren't like other reserved names (e.g. Print_Area) because they never appeared in the name box.

Gah! I can only vaguely remember that the names began with "_".

Can anyone help my to remember?

Well, I have to admit I remember something like that... but haven't found it yet. Found this in 'Excel 2002 VBA' though:

To summarize, you need to take care when using the following names:

* Criteria
* Database
* Extract
* Print_Area
* Print_Titles

Page 132, Chapter 6.