help for macro looping in excel

[monmon]

i have this code that needs to be loop nth time..

Sub Macro12()
'
' Macro12 Macro
'
 
'
    Range("A2:D6").Select
    Application.CutCopyMode = False
    Selection.Copy
    Range("E2").Select
    ActiveSheet.Paste
    Range("A7:D11").Select
    Application.CutCopyMode = False
    Selection.Copy
    Range("E7").Select
    ActiveSheet.Paste
    Range("E15").Select
End Sub
 

im a newbie in VB so dont know how to change the value of A2:D6 to increment to 5.. so it will be A7:D11 for the next loop. as well as where to paste E2 to E7.

[Rabbit]

It looks like you already have the two ranges in your code. Although it doesn't make sense why you would split it when you can just do it in one go by using A2:D11.

[zmbd]

do a search on relative cell address in VBA by opening the VBA editor to your code and press [F1] there is was a nice example in the [F1] files that will show you step by step.
Let us know if that isn't available to you.

[monmon]

its just actually copy A2:A6 then paste to B2. then copy A7:A11 then copy to B7. I just posted the two ranges to let the helper know the range from which the next loop would be.

[zmbd]

That's fine,
You still need to use the relative cell address with offset for movement.

[Rabbit]

What I'm trying to say is that copying A2:A6 and then copying A7:A11 is the same thing as just copying A2:A11.

[monmon]

nope.. because in the first range.. you have to paste it in b2.. second in b7

[Rabbit]

It's the same thing. Copying A2:A11 and pasting it into B2 is the exact same result as copying A2:A6, pasting into B2, then copying A7:A11, and pasting into B7.

[zmbd]

monmon:
Look, what we're getting at is that:
What you are doing within the code that you've already posted simply needs to be repeated.
I've told you to look-up "relative cell addressing" and the "Offset" method.
There is also in Excel VBA a direct method of selecting and pasting selected cells.
All of these methods are easily found by opening your VBA-Editor and searching help.
What you will not get here is a complete code .