Using Excel 2010
Hello,
Here below is a piece of code I have broken my head but cannot get it work the way I want.
I have some set of data in the range A2:C6 which I want to duplicate them in the row 20, 25, 30 and 35… code is working only for row 20 plese need help how can it be set for next to 25, 30, and for 35 row
Thank you.
Regards,
Moti
Hello,
Here below is a piece of code I have broken my head but cannot get it work the way I want.
I have some set of data in the range A2:C6 which I want to duplicate them in the row 20, 25, 30 and 35… code is working only for row 20 plese need help how can it be set for next to 25, 30, and for 35 row
VBA Code:
Sub DuplicateData()
For i = 2 To 5 Step 1
Cells(i, 1).Resize(2, 3).Copy
Cells(20, 1).PasteSpecial xlValues 'code write only in row 20 i want to next data to write in row 25,30 and 35
Next
Application.CutCopyMode = False
End Sub
Regards,
Moti