| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date copy paste should be very easy
Thank you very much Papou.
|
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date copy paste should be very easy
My pleasure.
Cordially Pascal "berk" a écrit dans le message de news: ... Thank you very much Papou. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and Paste Date - weird behavior | Excel Discussion (Misc queries) | |||
| Date copy, Paste error | Excel Discussion (Misc queries) | |||
| Copy/Paste Special (Date Format) | Excel Discussion (Misc queries) | |||
| fairly easy (i thought) copy and paste cells, increment by 17 accross | Excel Discussion (Misc queries) | |||
| fairly easy (i thought) copy and paste cells, increment by 17 accross | Excel Discussion (Misc queries) | |||
Hybrid Mode
