Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Range Names | Excel Discussion (Misc queries) | |||
range names | Excel Worksheet Functions | |||
Invalid Range Name | Excel Discussion (Misc queries) | |||
range names | Excel Worksheet Functions | |||
range names | Excel Worksheet Functions |