Here goes: I want to write a macro which will start at a specific cell and range like this A5356:B5360 , select this range then go 55 cells down and select the next 4(in the range). My recorded Macro is the following.
Sub Macro7()
'
' Macro7 Macro
'
' Keyboard Shortcut: Ctrl+q
'
Range("A4706:B4710,A4761:B4765,A4816:B4820,A4871:B 4875,A4926:B4930,A4981:B4985,A5036:B5040,A5091:B50 95,A5146:B5150,A5201:B5205,A5256:B5260,A5311:B5315 ,A5366:B5370").Select
Range("A5366").Activate
End Sub
I need this to do these steps allllll the way to the ending range of A141151:B141155. Obviously i don't want to write it in the single line single range form shown I need a "loop" process and then i need to apply the (+55 select 2x4 block and +55 select 2x4 block) formula. Please help i KNOW VBA can do this i just don't know how to tell it to