If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Why can't I call a range of cells 'c'?
Using "Insert|name|define" I have named certain ranges 'a', 'b' and 'd' (w/o
the '). I can't set up one called 'c' though - I get the message: "That name is not valid". I need the 'c' option as it will be in a drop down list to choose from. Any ideas? -- Traa Dy Liooar Jock |
#2
|
|||
|
|||
Why can't I call a range of cells 'c'?
c
is a reserved name. Use: c. instead -- Gary''s Student - gsnu200850 "Jock" wrote: Using "Insert|name|define" I have named certain ranges 'a', 'b' and 'd' (w/o the '). I can't set up one called 'c' though - I get the message: "That name is not valid". I need the 'c' option as it will be in a drop down list to choose from. Any ideas? -- Traa Dy Liooar Jock |
#3
|
|||
|
|||
Why can't I call a range of cells 'c'?
Thanks
-- Traa Dy Liooar Jock "Gary''s Student" wrote: c is a reserved name. Use: c. instead -- Gary''s Student - gsnu200850 "Jock" wrote: Using "Insert|name|define" I have named certain ranges 'a', 'b' and 'd' (w/o the '). I can't set up one called 'c' though - I get the message: "That name is not valid". I need the 'c' option as it will be in a drop down list to choose from. Any ideas? -- Traa Dy Liooar Jock |
#4
|
|||
|
|||
Why can't I call a range of cells 'c'?
I imagine that C looks too much like an address in both R1C1 reference style and
in A1 reference style. But why do you have to name anything C? I would think using something mnemonically significant would be much better than using a single character. NameList AddrList ChoiceList Almost anything would be better. Jock wrote: Using "Insert|name|define" I have named certain ranges 'a', 'b' and 'd' (w/o the '). I can't set up one called 'c' though - I get the message: "That name is not valid". I need the 'c' option as it will be in a drop down list to choose from. Any ideas? -- Traa Dy Liooar Jock -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|