Macro Code To Move Multiple Sheets To A Single(Same) New Workbook

[Karthik-Excelsior]

Hi Mr.Excel!

Hope you're doing good.

I've created a macro-enabled template, and as the final part of the macro, I should move two worksheets (say, Sheet2 & Sheet3) to a new workbook. I know how to move one worksheet to a new book (right click on the 'Sheet2' >> Move or Copy.. >> Select 'New Book') I want two sheets to be moved (simultaneously or otherwise) to the same NEW workbook. Is that possible?

Thanks for your help in advance!

Best,

Karthik

(Btw, You & Mike rock!!! Love ur vids on YT )

 

[VoG]

Click the first sheet's tab to select it. Then hold down CTRL and click on the second sheet's tab to add it to the selection. Then Right click.

 

[Karthik-Excelsior]

Hi Peter,

Thanks a ton.. that was so simple, and I wonder how I missed it all these days But, thanks for letting me know.

Best,

Karthik