PivotTable.PivotFormulas Property

  • Article
Excel Developer Reference

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

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

See Also