PivotFormulas.Item Method (Excel)

Returns a single object from a collection.

Syntax

expression. Item( _Index_ )

expression A variable that represents a PivotFormulas object.

Parameters

Name Required/Optional Data Type Description
Index Required Variant The name or index number for the object.

Return Value

A PivotFormula object contained by the collection.

Example

This example displays the first formula for PivotTable one on worksheet one.

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

See also

PivotFormulas Object