So I guess this leaves me with one last option - Is it possible
somehow to have a parent range from which named children ranges are
created such that the children ranges would be sorted but comprised of
non- contiguous cells within the parent range- maybe somehow using
offset/match combos? For example:

The parent range could include:

A1:B10 but one child range could be

A1:B2 & A4:B6 & A9:B10 ?

Also - is there a limit to the number of named ranges you can have?
And what does this do to file size and file speed?

Is another option I could use is rather than watching for
Worksheet_Change event watching for somekind of a Cell selection event
(eg. cursor is now on cell A10) from which I could then quickly run the
validation routine on only that cell rather than keeping the entire
200x6 = and thus at any give time, I'd only need a much smaller subset
of my name range validation lists/ranges?

Also - is there a limit to the number of named ranges you can have?
And what does this do to file size and file speed?

I suspect this is one of those limited by available memory. I doubt there
is an effect on speed unless they are dynamic/calculated. I wouldn't see
the storage being much more than that required for a cell but it isn't
anything I have ever experimented with.

You can have discontiguous ranges, so your sample child range could be a
valid range.

--
Regards,
Tom Ogilvy


" wrote in message
...
So I guess this leaves me with one last option - Is it possible
somehow to have a parent range from which named children ranges are
created such that the children ranges would be sorted but comprised of
non- contiguous cells within the parent range- maybe somehow using
offset/match combos? For example:

The parent range could include:

A1:B10 but one child range could be

A1:B2 & A4:B6 & A9:B10 ?

Also - is there a limit to the number of named ranges you can have?
And what does this do to file size and file speed?

Is another option I could use is rather than watching for
Worksheet_Change event watching for somekind of a Cell selection event
(eg. cursor is now on cell A10) from which I could then quickly run the
validation routine on only that cell rather than keeping the entire
200x6 = and thus at any give time, I'd only need a much smaller subset
of my name range validation lists/ranges?