date copy paste should be very easy
 

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

date copy paste should be very easy
 

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

"berk" a écrit dans le message de news:
...
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

date copy paste should be very easy
 

Thank you very much Papou.

date copy paste should be very easy
 

My pleasure.

Cordially
Pascal

"berk" a écrit dans le message de news:
...
Thank you very much Papou.