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

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

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

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