| title | Sheets.Copy method (Excel) | |
|---|---|---|
| keywords | vbaxl10.chm152074 | |
| f1_keywords |
|
|
| api_name |
|
|
| ms.assetid | 8cfee52e-dc0f-a54f-21ba-00a65ba2029c | |
| ms.date | 05/15/2019 | |
| ms.localizationpriority | medium |
Copies the sheet to another location in the workbook.
expression.Copy (Before, After)
expression A variable that represents a Sheets 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.
This example copies Sheet1, placing the copy after Sheet3.
Worksheets("Sheet1").Copy After:=Worksheets("Sheet3")[!includeSupport and feedback]