Greetings one and all and TIA for your time
I have obtained a non-contiguous range after performing the following:
isect = intersect(rng1, union(severalColumns))
myRange = isect.specialcells(xlconstants)
Now, myRange.areas are located on the worksheet in groups of 6 or more with
myRange.areas.cells(1) all on the same row within a group.
I need now to operate on each area in sequence, starting (looking at the
worksheet) from bottom group of areas, rightmost area. working left to last
area on row. Move up 1 to next row of areas. Start at right and work left...
Like reading a book in reverse.
How can I arange for the areas(indexnumbers) to be in the required sequence?
(or the reverse sequence is just as good) So that I can do:
for i = myRange.areas.count to 1 step -1
areas(i).dosomething
next

--
David