M
Mike H
Hi,
Why are C or c invalid names for named ranges on a worksheet?
Mike
Why are C or c invalid names for named ranges on a worksheet?
Mike
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Stefi
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:
I could name a range to both C and c in XL2003! Do you get any message?
Regards,
Stefi
„Mike H†ezt Ãrta:
M
Mike H
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
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
D
David Biddulph
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.
designations for column and row respectively. (Other letters are accepted.)
You can use R or C if preceded, or followed, by an underscore.
S
Stefi
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:
starting with an alpha character) or c2 (same as a cell reference) type names!
Stefi
„Mike H†ezt Ãrta:
M
Mike H
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-Naming-Cells-in-Microsoft-Excel&id=218607
Thanks for the Info'
Mike
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-Naming-Cells-in-Microsoft-Excel&id=218607
Thanks for the Info'
Mike
S
Stefi
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:
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:
M
Mike H
Mystery solved Thanks again to you both
Mike
Mike
Stefi said: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: