Arrays containing variable sheets

R

RichA

I am looking to be able to copy a number of sheets to a new workbook. However, these are not always the same sheets.


Sub Macro1()
Sheets(Array("SheetA", "SheetB")).Select
Sheets(Array("SheetA", "SheetB")).Copy
End Sub


How do I either:
(a) set the array to be the selected sheets prior to the macro being run? [I tried selectedsheets.select but it errored?]

(b) Creat an inputbox that allows an array of sheets (they are not always next to each other)?

Many thanks,
Rich
 
N

Norman Jones

I am looking to be able to copy a number of sheets to a new workbook. However, these are not always the same sheets.


Sub Macro1()
Sheets(Array("SheetA", "SheetB")).Select
Sheets(Array("SheetA", "SheetB")).Copy
End Sub


How do I either:
(a) set the array to be the selected sheets prior to the macro being run? [I tried selectedsheets.select but it errored?]

(b) Creat an inputbox that allows an array of sheets (they are not always next to each other)?

Many thanks,
Rich
Click to expand...
Hi Rich,

Try:

ActiveWindow.SelectedSheets.Copy


===
Regards,
Norman
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro VBA coding, Copying content from one workbook to a new one 0
Copy worksheet to another workbook 1
Possible to import a specific sheets data from excel into access? 1
Copy Array to Array, how to and should I? 13
Mail Multiple Sheets via PDF Q 5
Very Simple Copy and Paste Sheet - Error 3
Code copies twice...? 13
Array to Multiple Arrays 3

Top