PivotFormulas Collection Object

Description

Represents the collection of formulas for a PivotTable. Each formula is represented by a PivotFormula object.

Using the PivotFormulas Collection

Use the PivotFormulas method to return the PivotFormulas collection. The following example creates a list of pivot formulas for PivotTable one.

For Each pf in ActiveSheet.PivotTables(1).PivotFormulas
    Cells(r, 1).Value = pf.Formula
    r = r + 1
Next

Properties

Application property, Count property, Creator property, Parent property.

Methods

Add method (PivotFormulas collection), Item method (PivotFormulas collection).