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]

Thank you all for your quick replys.

I am almost pleased with myself for stumbling upon something you experts had
not, however I still have the issue. :(

I obviously will have to resort to a work-around, which is fine by me - but
I just know that once I release it to the troops I will hear many comments on
why I didn't do it the 'easy' way.

*sigh*
Jeffrey K. Ries


"Jake Marx" wrote:

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]

Hi Jeffrey,

Spongebob wrote:
I am almost pleased with myself for stumbling upon something you
experts had not, however I still have the issue. :(

I don't know if anyone was surprised but me, but I'm glad I could make you
feel better. <g

I obviously will have to resort to a work-around, which is fine by me
- but I just know that once I release it to the troops I will hear
many comments on why I didn't do it the 'easy' way.

That's one of the reasons I preface named ranges with something indicating
what they represent. For example, if a named range represents a column, I
may use "col_"; for a row, "row_"; for a range, "rng_"; hidden names are
"hb_" (boolean) or "hl_" (long), etc.

So in this case, you may want to preface the named ranges with something,
which in this case gives you the added benefit of avoiding built-in names.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

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

Unfortunately, I am using the result of one validation drop-down to filter
the results of the second drop-down. In other words, if I use names such as
you speak I would have to add them to the entries of the first drop-down.
This would look pretty confusing to the end-user.

Jeffrey K. Ries

"Jake Marx" wrote:

Hi Jeffrey,

Spongebob wrote:
I am almost pleased with myself for stumbling upon something you
experts had not, however I still have the issue. :(

I don't know if anyone was surprised but me, but I'm glad I could make you
feel better. <g

I obviously will have to resort to a work-around, which is fine by me
- but I just know that once I release it to the troops I will hear
many comments on why I didn't do it the 'easy' way.

That's one of the reasons I preface named ranges with something indicating
what they represent. For example, if a named range represents a column, I
may use "col_"; for a row, "row_"; for a range, "rng_"; hidden names are
"hb_" (boolean) or "hl_" (long), etc.

So in this case, you may want to preface the named ranges with something,
which in this case gives you the added benefit of avoiding built-in names.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

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

Jeffrey

You can use "c." as a valid range name. That may be less confusing, but
still get around the problem.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com

Spongebob wrote:
Unfortunately, I am using the result of one validation drop-down to
filter the results of the second drop-down. In other words, if I use
names such as you speak I would have to add them to the entries of
the first drop-down. This would look pretty confusing to the end-user.

Jeffrey K. Ries

"Jake Marx" wrote:

Hi Jeffrey,

Spongebob wrote:
I am almost pleased with myself for stumbling upon something you
experts had not, however I still have the issue. :(

I don't know if anyone was surprised but me, but I'm glad I could
make you feel better. <g

I obviously will have to resort to a work-around, which is fine by
me - but I just know that once I release it to the troops I will
hear many comments on why I didn't do it the 'easy' way.

That's one of the reasons I preface named ranges with something
indicating what they represent. For example, if a named range
represents a column, I may use "col_"; for a row, "row_"; for a
range, "rng_"; hidden names are "hb_" (boolean) or "hl_" (long), etc.

So in this case, you may want to preface the named ranges with
something, which in this case gives you the added benefit of
avoiding built-in names.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

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