Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Thanks
Thanks for the quick replies to both you, "Bernie", and "VBA Noob".
Appreciate your time! :) An Excel believer, CowgirlJen |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
missing cell borders in Excel | Excel Discussion (Misc queries) | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) |