Copy Multiple Sheets

  • Thread starter Thread starter Greg Rivet
  • Start date Start date
G

Greg Rivet

How can I copy multiple sheets (2-5) to a new workbook. I know I can do a
savea as, but then I lose the original, unless I reopen it. TIA

Greg
 
Click on the tab for sheet 2, hold down shift and then click on the tab for sheet 5. Now right
click and select 'move or copy', then select new book from the top dropdown, tick the 'create a
copy' at the bottom of the dialog box and hit OK.
 
How would you want to pick them, and are you looking to have this be part of a bigger routine??

The hardcoded routine would be along the following lines:-

Sub CopySheets()
Sheets(Array("WS1", "WS2", "WS3", "WS4")).Copy
End Sub
 
-----Original Message-----
How can I copy multiple sheets (2-5) to a new workbook. I know I can do a
savea as, but then I lose the original, unless I reopen it. TIA

Greg


.
Highlight sheet 2 and Try Edit - Move or Copy Sheet to a
Click to expand...
New Workbook and continue for sheets 3-5.
 
Back
Top