date copy paste should be very easy

's Computer Specifications

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

's Computer Specifications

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" <(E-Mail Removed)> a écrit dans le message de news:
(E-Mail Removed)...
> 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
>

's Computer Specifications

Thank you very much Papou.

's Computer Specifications

My pleasure.

Cordially
Pascal

"berk" <(E-Mail Removed)> a écrit dans le message de news:
(E-Mail Removed)...
> Thank you very much Papou.
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Easy eay to copy / paste a formula in column	watermt	Microsoft Excel Worksheet Functions	2	17th Nov 2009 03:22 PM
Copy/Paste cell down to next value- Easy question, can't figure it	J. Catz.	Microsoft Excel Misc	2	4th Nov 2009 10:45 AM
An Intelligent Way To Advocate For Vista [Easy Copy & Paste]	NoStop	Windows Vista General Discussion	18	4th Apr 2008 05:58 PM
Copy and paste easy questioin	a	Microsoft Access Form Coding	0	18th Feb 2008 07:39 PM
Copy / Paste Easy	willwonka	Microsoft Excel Programming	4	27th Jul 2006 03:05 PM