ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Copy/Paste question (https://www.excelbanter.com/excel-worksheet-functions/131794-copy-paste-question.html)

dan

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


All times are GMT +1. The time now is 09:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com