| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| call range by cell value | Excel Worksheet Functions | |||
| Formula to Sum cells below a target call | Excel Worksheet Functions | |||
| Select longest call duration from 2 cells and place in another cel | Excel Discussion (Misc queries) | |||
| Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
| how to compute a range of cells based on another range of cells? | Excel Worksheet Functions | |||
Linear Mode
