How to do a For Each and break up the range?

[ks100]

How would I specify the range for a "For Each cell in range" command if the ranges is fragmented.


In plain text I want it to do:


For each cell in range G2:G300 and range (user selected column1) : (user selected column1) and range (user selected column2) : (user selected column2), etc.....


Is this possible? If so what is the proper syntax?

[shg]

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.