| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
PivotItems.Add method (Excel) |
vbaxl10.chm248074 |
|
|
2d24bb3f-e765-c78c-bef0-787db82056c7 |
05/07/2019 |
medium |
Creates a new PivotTable item.
expression.Add (Name)
expression A variable that represents a PivotItems object.
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Name | Required | String | The name of the new PivotTable item. |
This example creates a new PivotTable item in the first PivotTable report on worksheet one.
Worksheets(1).PivotTables(1).PivotItems("Year").Add "1998"[!includeSupport and feedback]