Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
COPY AND PASTE MACRO
I want to record a macro that will copy cells B4:J7 and paste them starting at B10. Skipping two rows from the bottom of what I am copying. However, everytime I run the macro I want it to skip 2 rows two past. so the first time i run it it would paste in B10. The second time I run it would paste at B16 and so on and so forth. Any thoughts
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
COPY AND PASTE MACRO
does this help
x=cells(rows.count,"b").end(xlup).row+2 range("b4:j7").copy range("b" & x) -- Don Guillett SalesAid Software "Steven" wrote in message ... I want to record a macro that will copy cells B4:J7 and paste them starting at B10. Skipping two rows from the bottom of what I am copying. However, everytime I run the macro I want it to skip 2 rows two past. so the first time i run it it would paste in B10. The second time I run it would paste at B16 and so on and so forth. Any thoughts? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
COPY AND PASTE MACRO
Try...
Sub CopyRows() Range("B4:J7").Copy Destination:= _ Range("B" & Rows.Count).End(xlUp).Offset(3, 0) End Sub -----Original Message----- I want to record a macro that will copy cells B4:J7 and paste them starting at B10. Skipping two rows from the bottom of what I am copying. However, everytime I run the macro I want it to skip 2 rows two past. so the first time i run it it would paste in B10. The second time I run it would paste at B16 and so on and so forth. Any thoughts? . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
COPY AND PASTE MACRO
Dim rwct As Integer
Sub Copy+2 () rwct = Cells(Rows.Count, "B").End(xlUp).row Range("B4:J7").Copy Destination: = Range("B" & rwct + 3) End Sub Mike Steven wrote in message ... I want to record a macro that will copy cells B4:J7 and paste them starting at B10. Skipping two rows from the bottom of what I am copying. However, everytime I run the macro I want it to skip 2 rows two past. so the first time i run it it would paste in B10. The second time I run it would paste at B16 and so on and so forth. Any thoughts? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro - copy and paste value | Excel Discussion (Misc queries) | |||
Copy and Paste Macro | Excel Discussion (Misc queries) | |||
macro to copy and paste (to much for me) | Excel Discussion (Misc queries) | |||
macro to copy and paste | Excel Discussion (Misc queries) | |||
Macro Won't Copy/Paste | Excel Programming |