Chart.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. The Copy method is not supported for chart objects.

Copy (Before, After)

ActiveChart.Copy

Arguments

Optional arguments

The following arguments are optional

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

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