naming a range lower case c
Posted by Loren on March 23, 2001 6:09 AM
using Name Range Create and one range is c, it creates
the name as c_ Why would it do that?
Posted by mseyf on March 23, 2001 6:18 AM
my guess is that internally, Excel uses the letter 'c' to refer column c and Excel adds the '_' to prevent any conflicts. (case makes no difference in range names)
Mark
Posted by Dave Hawley on March 23, 2001 6:49 PM
Intresting, It also does the same with the letter "r" yet all the other letters of the alphabet it allows.
Dave
OzGrid Business Applications
Posted by Aladin Akyurek on March 24, 2001 1:27 AM
Then C probably refers to "COLUMN", R to "ROW"?
Posted by Dave Hawley on March 24, 2001 1:47 AM
Arrh, of course!
Well done Aladin, the old R1C1 reference! I clear case of not seeing the forest through the trees.
Dave
OzGrid Business Applications
