PivotFormula Object

Description

Represents a formula used to calculate results in a PivotTable.

Using the PivotFormula Object

Use PivotFormulas(index), where index is the formula number or string on the left side of the pivot formula, to return the PivotFormula object. The following example changes the index number for formula one so that it will be solved after formula two.

Worksheets(1).PivotTables(1).PivotFormulas(1).Index = 2

Properties

Application property, Creator property, Formula property, Index property, Parent property, Value property.

Methods

Delete method.