If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Copy and paste to the last row
Dear ALL, pls help me for macro.
I want copy the last row of column A, B and C. and Paste the row down. Example, my last row of A is A120, copy cell A120:C120. then Past to A121 Thanks so much |
#2
|
|||
|
|||
Copy and paste to the last row
hi
if i understand correctly, this should work for you.... Sub movedownone() Dim r As Range Set r = Range("A65000").End(xlUp) r.Resize(1, 3).Copy Destination:= _ r.Offset(1, 0) End Sub regards FSt1 "tran1728" wrote: Dear ALL, pls help me for macro. I want copy the last row of column A, B and C. and Paste the row down. Example, my last row of A is A120, copy cell A120:C120. then Past to A121 Thanks so much |
#3
|
|||
|
|||
Copy and paste to the last row
Yes , exactely that i want, thanks so much.
"FSt1" wrote: hi if i understand correctly, this should work for you.... Sub movedownone() Dim r As Range Set r = Range("A65000").End(xlUp) r.Resize(1, 3).Copy Destination:= _ r.Offset(1, 0) End Sub regards FSt1 "tran1728" wrote: Dear ALL, pls help me for macro. I want copy the last row of column A, B and C. and Paste the row down. Example, my last row of A is A120, copy cell A120:C120. then Past to A121 Thanks so much |
#4
|
|||
|
|||
Copy and paste to the last row
tran1728;952064 Wrote: Yes , exactely that i want, thanks so much. "FSt1" wrote: - hi if i understand correctly, this should work for you.... Sub movedownone() Dim r As Range Set r = Range("A65000").End(xlUp) r.Resize(1, 3).Copy Destination:= _ r.Offset(1, 0) End Sub regards FSt1 "tran1728" wrote: - Dear ALL, pls help me for macro. I want copy the last row of column A, B and C. and Paste the row down. Example, my last row of A is A120, copy cell A120:C120. then Past to A121 Thanks so much -- excel is very flexible tool, you can record a macro manually and excute it (play with it) all the best -- bala_vb |
Thread Tools | |
Display Modes | |
|
|