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]