ExcelBanter - Make a copy of a sheet and add it into a new workbook?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Make a copy of a sheet and add it into a new workbook? (https://www.excelbanter.com/excel-programming/409701-make-copy-sheet-add-into-new-workbook.html)

NateBuckley

Make a copy of a sheet and add it into a new workbook?

Hello, I know how to copy and paste data from one sheet to another with ranges

but I'm just wondering if there is an easier way by simply stating something
like

Workbooks("Backup.xls").Sheets("Data") =
Workbooks("Project.xls").Sheets("Data")

Thanks in advance!!

Nate

All times are GMT +1. The time now is 05:32 AM.