I need to copy multiple sheets that contain tables into a new workbook.
I am trying to do this with the following code, but I am getting an error:
Error:
Can someone please tell me how to do this successfully?
Thanks in advance.
I am trying to do this with the following code, but I am getting an error:
VBA Code:
Sheets(Array(s1, "Sheet1","Sheet2")).Select
ActiveWindow.SelectedSheets.Copy
Code:
you cannot move or copy a group of sheets that contain a table.
Thanks in advance.