Need list of Excel reserved words

T

Travis

Well-known Member

Joined

Feb 26, 2002

Messages

1,711

• Sep 22, 2003

• #2

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

 

Upvote 0

J

jacobskl

New Member

Joined

Sep 22, 2003

Messages

5

• Sep 22, 2003

• #3

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.

 

Upvote 0

T

Travis

Well-known Member

Joined

Feb 26, 2002

Messages

1,711

• Sep 22, 2003

• #4

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.

 

Upvote 0

M

Mark W.

MrExcel MVP

Joined

Feb 10, 2002

Messages

11,654

• Sep 22, 2003

• #5

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

 

Upvote 0

J

jacobskl

New Member

Joined

Sep 22, 2003

Messages

5

• Sep 22, 2003

• #6

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!)

 

Upvote 0

P

PaddyD

MrExcel MVP

Joined

May 1, 2002

Messages

14,234

• Sep 22, 2003

• #7

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).

 

Upvote 0

Mark O'Brien

MrExcel MVP

Joined

Feb 15, 2002

Messages

3,530

• Sep 22, 2003

• #8

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?

 

Upvote 0

J

jacobskl

New Member

Joined

Sep 22, 2003

Messages

5

• Sep 22, 2003

• #9

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.

 

Upvote 0

J

Juan Pablo González

MrExcel MVP

Joined

Feb 8, 2002

Messages

11,959

• Sep 22, 2003

• #10

Mark O'Brien said:

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?

Click to expand...

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

Stephen Bullen said:

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

* Criteria
* Database
* Extract
* Print_Area
* Print_Titles

Click to expand...

Page 132, Chapter 6.

 

Upvote 0