"Static" code to combine three ranges would be
Can't fathom how to combine them as "variable" ranges?![]()
For Each c In Range("AA106:AE108,AI107:AM108,AR106,AV108")
All suggestions and pointers appreciated![]()
For Each c In Range((Range(Range("AA" & j), Range("AE" & k)), Range(Range("AI" & j), Range("AM" & k)), Range(Range("AR" & j), Range("AV" & k)))
Ochimus
Bookmarks