I am working on a tamplte which uses data validation to create drop-down
lists. From the answers in one drop-down I use the "INDIRECT" function to
call the list for a second drop-down. This works very well except that one
of my listings for the first drop-down is the letter "C". They are all
letters, and I have set up named lists for all of them. However, when I
attempt to set up a named list with the letter "C" as it's name I get
"Invalid Name".

Is this name reserved for some other reason?

Jeffrey K. Ries

Hi Jeffrey

it looks like "c" as range name is not allowed .. if i create a range using
insert / name / create ... the column headed "c" has a range name created of
"c_"

can't think of a workaround :(

Cheers
JulieD

"Spongebob" wrote in message
...
I am working on a tamplte which uses data validation to create drop-down
lists. From the answers in one drop-down I use the "INDIRECT" function to
call the list for a second drop-down. This works very well except that
one
of my listings for the first drop-down is the letter "C". They are all
letters, and I have set up named lists for all of them. However, when I
attempt to set up a named list with the letter "C" as it's name I get
"Invalid Name".

Is this name reserved for some other reason?

Jeffrey K. Ries

Hi Jeffrey,

I've never noticed that before, but it looks like "c" and "r" cannot be used
as names. If you type "c" or "r" in the name box, the active cell's column
or row, respectively, is selected.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Spongebob wrote:
I am working on a tamplte which uses data validation to create
drop-down lists. From the answers in one drop-down I use the
"INDIRECT" function to call the list for a second drop-down. This
works very well except that one of my listings for the first
drop-down is the letter "C". They are all letters, and I have set up
named lists for all of them. However, when I attempt to set up a
named list with the letter "C" as it's name I get "Invalid Name".

Is this name reserved for some other reason?

Jeffrey K. Ries

Grüezi Jake

Jake Marx schrieb am 28.02.2005

I've never noticed that before, but it looks like "c" and "r" cannot be used
as names. If you type "c" or "r" in the name box, the active cell's column
or row, respectively, is selected.

Here with German region-settings these are the letters 'Z' and 'S'.

.....which would result that these letters are reseved for internal use and
not for use as a variable or range name.


Regards
Thomas Ramel

--
- MVP for Microsoft-Excel -
[Win XP Pro SP-2 / xl2000 SP-3]

or A1 or B9 or RC or almost anything that looks like a range reference.

--
Regards,
Tom Ogilvy


"Jake Marx" wrote in message
...
Hi Jeffrey,

I've never noticed that before, but it looks like "c" and "r" cannot be
used
as names. If you type "c" or "r" in the name box, the active cell's
column
or row, respectively, is selected.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


Spongebob wrote:
I am working on a tamplte which uses data validation to create
drop-down lists. From the answers in one drop-down I use the
"INDIRECT" function to call the list for a second drop-down. This
works very well except that one of my listings for the first
drop-down is the letter "C". They are all letters, and I have set up
named lists for all of them. However, when I attempt to set up a
named list with the letter "C" as it's name I get "Invalid Name".

Is this name reserved for some other reason?

Jeffrey K. Ries

Hi Tom,

Tom Ogilvy wrote:
or A1 or B9 or RC or almost anything that looks like a range
reference.

I was aware of those, but the "c" and "r" behavior took me by surprise.
Maybe I just haven't been paying attention. <g

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

R1C1 notation or had you already surmised that. R is entire row, C is
entire column.

--
Regards,
Tom Ogilvy

"Jake Marx" wrote in message
...
Hi Tom,

Tom Ogilvy wrote:
or A1 or B9 or RC or almost anything that looks like a range
reference.

I was aware of those, but the "c" and "r" behavior took me by surprise.
Maybe I just haven't been paying attention. <g

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

Tom Ogilvy wrote:
R1C1 notation or had you already surmised that. R is entire row, C
is entire column.

I figured it had to do with R1C1 notation, but I had never seen the behavior
before. I see that typing R2C takes me to the second row and the active
cell's column. Interesting, but probably not something I'll use. I don't
use R1C1 notation much anyway....

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]