That could be a problem - putting all the arrays back onto the sheet -
The reason is this: For each set of 6 cells in 1 row there are 4
ranges that govern the allowable values. Since the relationships are
two-way, then in reality I might need 8 ranges - 1 sorted for each of
the two columns in each range. Then I'm likely to have upwards of 200
rows - each with one of the 6 cells. That means that I could need 1600
columns of ranges - that's probably not a good solution then. I'd
really need to find a way to assign the array values to a range then is
then used for validation. Is it not possible to define a range in VB
that never gets put to the worksheet?

No! A range is a worksheet object/property. It doesn't
exist otherwise. Unless you need hard copy, try processing
the arrays as arrays, else write the data to the sheet
using a relative offset for spacing. Excel nor vba care
about the size or the count.

-----Original Message-----
That could be a problem - putting all the arrays back
onto the sheet -
The reason is this: For each set of 6 cells in 1 row
there are 4
ranges that govern the allowable values. Since the
relationships are
two-way, then in reality I might need 8 ranges - 1 sorted
for each of
the two columns in each range. Then I'm likely to have
upwards of 200
rows - each with one of the 6 cells. That means that I
could need 1600
columns of ranges - that's probably not a good solution
then. I'd
really need to find a way to assign the array values to a
range then is
then used for validation. Is it not possible to define a
range in VB
that never gets put to the worksheet?

.

Is it not possible to define a range in VB
that never gets put to the worksheet?

No.

Regards,
Tom Ogilvy

" wrote in message
...
That could be a problem - putting all the arrays back onto the sheet -
The reason is this: For each set of 6 cells in 1 row there are 4
ranges that govern the allowable values. Since the relationships are
two-way, then in reality I might need 8 ranges - 1 sorted for each of
the two columns in each range. Then I'm likely to have upwards of 200
rows - each with one of the 6 cells. That means that I could need 1600
columns of ranges - that's probably not a good solution then. I'd
really need to find a way to assign the array values to a range then is
then used for validation. Is it not possible to define a range in VB
that never gets put to the worksheet?