Item Method (PivotFormulas Collection)

Applies To

PivotFormulas collection object.

Description

Returns a single PivotFormula object from a PivotFormulas collection.

Syntax

expression.Item(Index)

expression Required. An expression that returns a PivotFormulas object.

Index Required Variant. The index number of the pivot formula.

Example

This example displays the formula for pivot formula one.

MsgBox Worksheets(1).PivotTables(1).PivotFormulas.Item(1).Formula