Sheets.Copy Method (Excel)
Copies the sheet to another location in the workbook.
Syntax
expression .Copy(Before, After)
expression A variable that represents a Sheets object.
Parameters
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. |
Remarks
If you don't specify either Before or After, Microsoft Excel creates a new workbook that contains the copied sheet.
Example
This example copies Sheet1, placing the copy after Sheet3.
Worksheets("Sheet1").Copy After:=Worksheets("Sheet3")