Copy sheets, keep the format in a new workbook

hi,

I've found here this code, it works great, with an InputBox I add the new sheet's name, it copies my table, keeps the format, from activesheet in the same workbook.
What I want is to copy all sheets with a specific range from my workbook but in a new file, to be created a new one, having the same name, somewhere on desktop (.xls).
So, in the new file to have the same sheets but with the specified range.(range A1:aa50) .
I appreciate any suggestions!

Please Login or Register  to view this content.

any suggestions?...

I think the simplest way is to copy the workbook and to delete everything in the new file you don't need.

Use

Please Login or Register  to view this content.

to copy your workbook.

hi snb,
Thank you for your help.
I used this one, I thought it was any other way ...!

I can leave it...