Re: Loop in copy paste code
Logically, Yes, you can do it. Programatically, it depends on how are your ranges placed. What are the names of the bookmark. Does the name of the bookmark follow a pattern etc... etc...
Few Tips
Sheets("Sheet1") can also be written as Sheets(1)
Range("A1") can also be written as Range("A" & i)
same goes with bookmark...
See the following code. The code doesn't do anything... It is just to show you how to work with your code...
Code:
Sub Example()
i = 2
j = 5
a = "Sheet" & i '<-- "Sheet2"
Sheets(a).Range("A" & i).Copy '<--- Range("A2")
Bmark = "Bookmark" & i '<--- "Bookmark2"
Rng = Range("A" & i & ":B" & j).Address '<--- Range("A2:B5")
End Sub
Try it out. If you still get stuck... Yell :) This forum will definitely help you out. It always does :)