Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Last Draw & Paste
I need a VBA which will always copy the last row of every sheet an
paste on the last row + 1 of the individual sheets. I record the macro but that is not what I want and I don't know how t modify the macro to make it works. Can someone help? Regards Michae -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Last Draw & Paste
Can you pick out a column that you can use to determine the lastused row?
I used column A for this code: Option Explicit Sub testme() Dim LastRow As Long Dim wks As Worksheet For Each wks In ActiveWorkbook.Worksheets With wks LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row .Rows(LastRow).Copy _ Destination:=.Rows(LastRow + 1) End With Next wks End Sub "Michael168 <" wrote: I need a VBA which will always copy the last row of every sheet and paste on the last row + 1 of the individual sheets. I record the macro but that is not what I want and I don't know how to modify the macro to make it works. Can someone help? Regards Michael --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
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; 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) | |||
how do i draw a textbox on chart and copy onto word? | Charts and Charting in Excel |