PivotFormulas.Item Method (Excel)

Returns a single object from a collection.


expression. Item( _Index_ )

expression A variable that represents a PivotFormulas object.


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.


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