vba code to copy and select two tables to a new workbook

[jlabrecque]

Hi can someone help me with some code.

I have one work book with two tables "Table1" and "Table2" both are on separate worksheets.

I want to copy these tables to a new workbook and each on a separate worksheet.

Can someone please help me with the code of copying the two tables. I tried to figure it out using an array but I am new to vba and was unsuccessful.

thank you

 

[DanteAmor]

If the table is the only thing that exists on the sheet, then you can copy the 2 sheets and create a new book:

Sub Create
    Sheets(Array("sheet1", "sheet2")).Copy
End Sub

 

[jlabrecque]

how would you code it if the sheets are across multiple worksheets

i.e worksheet1 tab 1
worksheet2 tab 2

Thank you

 

[jlabrecque]

please ignore my response