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!

Hi,

This link might help

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

VBA Noob

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" <CowgirlJen@discussions.microsoft.com> wrote in message
news:15F1A7E1-15C9-4762-8EA8-3B34AD2E9579@microsoft.com...
> 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!

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
news:OkG7D8rpGHA.3288@TK2MSFTNGP03.phx.gbl...
> 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" <CowgirlJen@discussions.microsoft.com> wrote in message
> news:15F1A7E1-15C9-4762-8EA8-3B34AD2E9579@microsoft.com...
>> 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 for the quick replies to both you, "Bernie", and "VBA Noob".
Appreciate your time!

An Excel believer,
CowgirlJen

No Problem

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