| title | keywords | f1_keywords | ms.assetid | ms.date | ms.localizationpriority | |
|---|---|---|---|---|---|---|
Sheets.Add2 method (Excel) |
vbaxl10.chm152090 |
|
f44b3ef1-8452-4e26-b91c-d24124fa5bc6 |
05/15/2019 |
medium |
This method is only implemented for the Charts collection object and will produce a run-time error if used on the Sheets and Worksheets objects.
expression.Add2 (Before, After, Count, NewLayout)
expression A variable that represents a Sheets object.
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Before | Optional | Variant | An object that specifies the sheet before which the new sheet is added. |
| After | Optional | Variant | An object that specifies the sheet after which the new sheet is added. |
| Count | Optional | Variant | The number of sheets to be added. The default value is one. |
| NewLayout | Optional | Variant | The layout of the new worksheet. |
Object
[!includeSupport and feedback]