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?