View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dan dan is offline
external usenet poster
 
Posts: 866
Default Copy/Paste question

Have data in one workbook and want to copy it to bottom of another workbook.
Below is the code I have:

Set VMM_Workbook_C = ActiveWorkbook
Rows("6:6").Select
Range(Selection, Selection.End(xlDown)).Copy

VMM_Workbook_B.Activate
Last_Row = Cells(Rows.Count, "A").End(xlUp).Row + 1

What would be the Paste command to insert the information at the "Last_Row"?

Thanks