Item Method (PivotTables Collection)

Applies To

PivotTables collection object.

Description

Returns a single PivotTable object from a PivotTables collection.

Syntax

expression.Item(Index)

expression Required. An expression that returns a PivotTables object.

Index Required Variant. The name or index number of the PivotTable.

Example

This example makes the Year field a row field in PivotTable one on Sheet3.

Worksheets("Sheet3").PivotTables.Item(1) _
    .PivotFields("Year").Orientation = xlRowField