Item Method (PivotItems Collection)

Applies To

PivotItems collection object.

Description

Returns a single PivotItem object from a PivotItems collection.

Syntax

expression.Item(Index)

expression Required. An expression that returns a PivotItems object.

Index Required Variant. The name or index number of the pivot item.

Example

This example hides the "1998" item in PivotTable one on Sheet3.

Worksheets("Sheet3").PivotTables(1) _
    .PivotFields("Year").PivotItems.Item("1998").Visible = False