PivotTable.PivotFormulas Property (Excel)
Returns a PivotFormulas object that represents the collection of formulas for the specified PivotTable report. Read-only.
Syntax
expression .PivotFormulas
expression A variable that represents a PivotTable object.
Remarks
For OLAP data sources, this property returns an empty collection.
Example
For Each pf in ActiveSheet.PivotTables(1).PivotFormulas
r = r + 1
Cells(r, 1).Value = pf.Formula
Next