Why can't I name a cell "c" in Excel?

C

CowgirlJen

I've noticed that a cell cannot be named "c" within Excel. I've also noticed
the column in which the cell resides will be highlighted after I try this.
Any explanations? The Help files don't provide me with an answer...

Thanks!
 
B

Bernie Deitrick

Cowgirl,

The names R and C, and names beginning with R of C and immediately followed by an integer are not
allowed, due to the R1C1 notation used in formulas when the A1 notation is not used.

HTH,
Bernie
MS Excel MVP
 
B

Bernie Deitrick

I should have also noted that any valid cell address is not allowed as a name C1, C2, etc are all
unallowed names as well...

HTH,
Bernie
MS Excel MVP
 
C

CowgirlJen

Thanks for the quick replies to both you, "Bernie", and "VBA Noob".
Appreciate your time! :)

An Excel believer,
CowgirlJen
 
Top