Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reserved words
Hi,
Why are C or c invalid names for named ranges on a worksheet? Mike |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reserved words
Hi Mike,
I could name a range to both C and c in XL2003! Do you get any message? Regards, Stefi €˛Mike H€¯ ezt Ć*rta: Hi, Why are C or c invalid names for named ranges on a worksheet? Mike |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reserved words
Stefi,
Using Insert|Name|Define in XL2003 I get a popup error if I use C or c. 'The name is not Valid' I Googled it but got nothing. Mike "Stefi" wrote: Hi Mike, I could name a range to both C and c in XL2003! Do you get any message? Regards, Stefi €˛Mike H€¯ ezt Ć*rta: Hi, Why are C or c invalid names for named ranges on a worksheet? Mike |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reserved words
If my memory serves me right, C and R can't be used by they are used as
designations for column and row respectively. (Other letters are accepted.) You can use R or C if preceded, or followed, by an underscore. -- David Biddulph "Mike H" wrote in message ... Hi, Why are C or c invalid names for named ranges on a worksheet? Mike |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reserved words
It's strange! The only way I could get this error message was using 2c (not
starting with an alpha character) or c2 (same as a cell reference) type names! Stefi €˛Mike H€¯ ezt Ć*rta: Stefi, Using Insert|Name|Define in XL2003 I get a popup error if I use C or c. 'The name is not Valid' I Googled it but got nothing. Mike "Stefi" wrote: Hi Mike, I could name a range to both C and c in XL2003! Do you get any message? Regards, Stefi €˛Mike H€¯ ezt Ć*rta: Hi, Why are C or c invalid names for named ranges on a worksheet? Mike |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reserved words
David,
That seems sensible and I do get the same error when trying to use R but it doesn't explain why Stefi doesn't get the error with C. I'm not sure how authorative this is but there is no mention of this seemingly undocumented feature here. http://ezinearticles.com/?Rules-For-...xcel&id=218607 Thanks for the Info' Mike "David Biddulph" wrote: If my memory serves me right, C and R can't be used by they are used as designations for column and row respectively. (Other letters are accepted.) You can use R or C if preceded, or followed, by an underscore. -- David Biddulph "Mike H" wrote in message ... Hi, Why are C or c invalid names for named ranges on a worksheet? Mike |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reserved words
David is right, C and R stands for column and row respectively. The reason
why my Excel accepted these letters is that I use a national language version in which O and S are the equivalents of C and R. Using O or S I got the error message! And also Mike is right when he misses documentation of this constraint! Stefi €˛Mike H€¯ ezt Ć*rta: David, That seems sensible and I do get the same error when trying to use R but it doesn't explain why Stefi doesn't get the error with C. I'm not sure how authorative this is but there is no mention of this seemingly undocumented feature here. http://ezinearticles.com/?Rules-For-...xcel&id=218607 Thanks for the Info' Mike "David Biddulph" wrote: If my memory serves me right, C and R can't be used by they are used as designations for column and row respectively. (Other letters are accepted.) You can use R or C if preceded, or followed, by an underscore. -- David Biddulph "Mike H" wrote in message ... Hi, Why are C or c invalid names for named ranges on a worksheet? Mike |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reserved words
Mystery solved Thanks again to you both
Mike "Stefi" wrote: David is right, C and R stands for column and row respectively. The reason why my Excel accepted these letters is that I use a national language version in which O and S are the equivalents of C and R. Using O or S I got the error message! And also Mike is right when he misses documentation of this constraint! Stefi €˛Mike H€¯ ezt Ć*rta: David, That seems sensible and I do get the same error when trying to use R but it doesn't explain why Stefi doesn't get the error with C. I'm not sure how authorative this is but there is no mention of this seemingly undocumented feature here. http://ezinearticles.com/?Rules-For-...xcel&id=218607 Thanks for the Info' Mike "David Biddulph" wrote: If my memory serves me right, C and R can't be used by they are used as designations for column and row respectively. (Other letters are accepted.) You can use R or C if preceded, or followed, by an underscore. -- David Biddulph "Mike H" wrote in message ... Hi, Why are C or c invalid names for named ranges on a worksheet? Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is a 'reserved name' and how do I get rid of it? | Excel Discussion (Misc queries) | |||
Renaming Worksheet: Error message: "Reserved Name" | Excel Discussion (Misc queries) | |||
File is "Reserved" | New Users to Excel | |||
Reserved by - Protected | Excel Worksheet Functions | |||
reserved sheet name | Excel Worksheet Functions |