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.Please Login or Register to view this content.
Bookmarks