MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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