loop through ranges
I'm suffering from brain freeeze at the moment...
Assuming i've already used Dim and Set, i have something like:
For Each cl in myRng1
Do something dependent on this range
Next cl
For Each cl in myRng2
Do something dependent on this range
Next cl
How could i loop through ranges something like:
for i = 1 to 2
for each cl in (what to use here?)
Do something (function of i)
Next cl
Next i
I can sort the (function of i) bit, it's looping through range names where
i'm stuck
Thanks
|