I have the following code to copy some worksheets to a new workbook:
How would I modify this so sheet1 is a xlPasteAll instead of an xlPasteValues? I tried copying the For/Next loop, but it just creates another workbook.Sheets(Array("sheet1", "sheet2", "sheet3", "sheet4", "sheet5")).Copy For Each wst In Worksheets With Cells .Copy .PasteSpecial xlPasteValues End With Range("A1").Select Next wst
Bookmarks