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]