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]