Hi I currently have a workbook with 3 tabs (3 worksheets). One of them is called MTS. Currently, I have a macro that says

Sheets("MTS").Activate
Sheets("MTS").Copy

And then the rest of the macro runs instructions on the new worksheet.

The prob is that I need to paste special formats only to the new workbook so the formulas don't remain active

Does anyone know any VBA code that does this easily?

Thanks so much