date copy paste should be very easy

  • Thread starter Thread starter berk
  • Start date Start date
B

berk

Hi

I have cells Jan-07 Feb-07...etc (J3:U3).
I need copy paste 8 times to destination cells J13:U13 -J23:U23 -
J33:U33...etc
Is it possible to solve with macro.

Thanks

Best Regards
 
Hello berk
Sub CopyMyDates()
Dim n As Long, i As Long
n = 10
For i = 1 To 8
Range("J3:U3").Copy Range(Cells(3 + n, "J"), Cells(3 + n, "U"))
n = n + 10
Next i
End Sub


HTH
Cordially
Pascal
 
Back
Top