Hello,
I have a ss with values in rows 7-11, and 14-21 that I would like to loop through. Currently I use the following construction:
I have a ss with values in rows 7-11, and 14-21 that I would like to loop through. Currently I use the following construction:
Code:
For r = 7 to 11
statements
Next r
For r = 14 to 21
statements
Next r
[\code]
What I would like to do, ideally, is combine this into one loop that looks something like:
For r = 7 to 11, 14 to 21 which doesn't work
I've tried even listing the numbers in () like (7, 8, 9, ...) and without the commas.
I've tried the For Each r In (7, 8, 9, ...) but that doesn't work either.
Any ideas would be helpful.
Thanks,
George Teachman