PivotFormulas Property

Microsoft Excel Visual Basic

Show All

PivotFormulas Property

       

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

expression.PivotFormulas

expression   Required. An expression that returns a PivotTable object.

Remarks

For OLAP data sources, this property returns an empty collection.

Example

This example creates a list of formulas for PivotTable one.

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