"Static" code to combine three ranges would be


For Each c In Range("AA106:AE108,AI107:AM108,AR106,AV108")
Can't fathom how to combine them as "variable" ranges?


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)))
All suggestions and pointers appreciated

Ochimus