Chart.Copy method (Excel)
Copies the sheet to another location in the workbook.
expression.Copy (Before, After)
expression A variable that represents a Chart object.
Name | Required/Optional | Data type | Description |
---|---|---|---|
Before | Optional | Variant | The sheet before which the copied sheet will be placed. You cannot specify Before if you specify After. |
After | Optional | Variant | The sheet after which the copied sheet will be placed. You cannot specify After if you specify Before. |
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.
This example copies Sheet1, placing the copy after Sheet3.
Worksheets("Sheet1").Copy After:=Worksheets("Sheet3")
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.