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

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!

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

Hi,

This link might help

http://www.cpearson.com/excel/named.htm

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=561252

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

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


"CowgirlJen" wrote in message
...
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!

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

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


"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
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


"CowgirlJen" wrote in message
...
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!

Thanks
 

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

An Excel believer,
CowgirlJen

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

No Problem


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=561252

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

VBA Noob wrote:
Hi,

This link might help

http://www.cpearson.com/excel/named.htm

VBA Noob


And then again, it might not.

Alan Beban