Returns a single object from a collection.
expression . Item( Index )
expression A variable that represents a CalculatedItems object.
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Index | Required | Variant | The name or index number for the object. |
A PivotItem object contained by the collection.
The text name of the object is the value of the Name and Value properties.
This example hides calculated item one.
Worksheets(1).PivotTables(1).PivotFields("year") _
.CalculatedItems.Item(1).Visible = False