Home |
Search |
Today's Posts |
#1
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
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
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
|
|||
|
|||
Quote:
all the best
__________________
Thanks Bala |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Copy, paste without file name referenced after paste | Excel Discussion (Misc queries) | |||
Copy; Paste; Paste Special are disabled | Excel Discussion (Misc queries) | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) |