|
| 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
May 7th, 2010, 03:23 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
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
May 7th, 2010, 05:13 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
May 7th, 2010, 08:32 AM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
May 7th, 2010, 07:50 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 | |
|
|
Linear Mode
