Invalid Range Names
 

Excel 2000 -

I am trying to assign Range Names as four character combinations. I have
noticed that some are not valid.

Example "aaa3" is valid but "aa83" is not.

Why? Are there some naming restrictions?

For one thing.........AA83 is a cell address..........you could use AA_83 as
a RangeName


Vaya con Dios,
Chuck, CABGx3


"Old Music Lover" wrote in message
nk.net...
Excel 2000 -

I am trying to assign Range Names as four character combinations. I have
noticed that some are not valid.

Example "aaa3" is valid but "aa83" is not.

Why? Are there some naming restrictions?

aa83 is a cell in the sheet, you won't be able to use a two letter-two number
combination unless it's IW or higher

"Old Music Lover" wrote:

Excel 2000 -

I am trying to assign Range Names as four character combinations. I have
noticed that some are not valid.

Example "aaa3" is valid but "aa83" is not.

Why? Are there some naming restrictions?

You were right on the money! Thanx, you just saved me a ton of time.


"CLR" wrote in message
...
For one thing.........AA83 is a cell address..........you could use AA_83
as
a RangeName


Vaya con Dios,
Chuck, CABGx3


"Old Music Lover" wrote in message
nk.net...
Excel 2000 -

I am trying to assign Range Names as four character combinations. I have
noticed that some are not valid.

Example "aaa3" is valid but "aa83" is not.

Why? Are there some naming restrictions?

You're welcome............happy to help

Vaya con Dios,
Chuck, CABGx3


"Old Music Lover" wrote in message
hlink.net...
You were right on the money! Thanx, you just saved me a ton of time.


"CLR" wrote in message
...
For one thing.........AA83 is a cell address..........you could use
AA_83
as
a RangeName


Vaya con Dios,
Chuck, CABGx3


"Old Music Lover" wrote in message
nk.net...
Excel 2000 -

I am trying to assign Range Names as four character combinations. I
have
noticed that some are not valid.

Example "aaa3" is valid but "aa83" is not.

Why? Are there some naming restrictions?