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.