Sheets.Copy (Excel)

Copies the sheet to another location in the workbook.

If you don't specify either Before or After, Microsoft Excel creates a new workbook that contains the copied sheet.

Copy (Before, After)

Worksheets("Sheet1").Copy After:=Worksheets("Sheet3")

Arguments

Optional arguments

The following arguments are optional

Before (Chart) - The sheet before which the copied sheet will be placed. You cannot specify Before if you specify After.

After (Chart) - The sheet after which the copied sheet will be placed. You cannot specify After if you specify Before.