VB Code for copying

samuels90 · Jul 21st 2004

How do I write a dynamic range in VB? For ex. I would like to copy the area
: b1 to d10, one row at a time. i.e. b1..d1, then return to to b2, select
: b2..d2 and copy that range until all ten rows are copied.
:
: Any thoughts?
:

Jong · Jul 21st 2004

Code

For I=1 to 10


Worksheets("My sheet").Range("B" & I & ":D" & I).Copy
Worksheets("My Sheet").Range("F" & I & ":H" & I).PasteSpecial Paste:=xlPasteAll


Next I

VB Code for copying

Participate now!

Share