PivotFormulas Method

Applies To

PivotTable object.

Description

Returns a PivotFormulas object that represents the collection of pivot formulas for the PivotTable. Read-only.

Syntax

expression.PivotFormulas( )

expression Required. An expression that returns a PivotTable object.

Example

This example creates a list of pivot formulas for PivotTable one.

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