| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
Sheets.Move method (Excel) |
vbaxl10.chm152079 |
|
|
8cfb8888-b676-15ba-47eb-9d3d4dae5416 |
05/15/2019 |
medium |
Moves the sheet to another location in the workbook.
expression.Move (Before, After)
expression A variable that represents a Sheets object.
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Before | Optional | Variant | The sheet before which the moved sheet will be placed. You cannot specify Before if you specify After. |
| After | Optional | Variant | The sheet after which the moved 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 moved sheet.
This example moves Sheet1 after Sheet3 in the active workbook.
Worksheets("Sheet1").Move _
after:=Worksheets("Sheet3")[!includeSupport and feedback]