Worksheets.Move Method
| Excel Developer Reference |
Moves the sheet to another location in the workbook.
Syntax
expression.Move(Before, After)
expression A variable that represents a Worksheets object.
Parameters
| 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. |
Remarks
If you don't specify either Before or After, Microsoft Excel creates a new workbook that contains the moved sheet.
Example
This example moves Sheet1 after Sheet3 in the active workbook.
| Visual Basic for Applications |
|---|
|
See Also