help with a save code

[JasonLeVan]

is there a code that i can use to take sheet3 and resave it as its own workbook called sheet3new

 

[Jon von der Heyden]

You can use the sheet Copy method. If you don't specify a destination then this method creates a new workbook.

E.g.

Sheet3.Copy
ActiveWorkbook.SaveAs "C:\Sheet3New.xlsx"