Export (0) Print
Expand All

PivotFormulas Collection Object [Excel 2003 VBA Language Reference]

Office 2003
PivotTable
PivotFormulas
PivotFormula

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

Remarks

This object and its associated properties and methods aren't available for OLAP data sources because calculated fields and items aren't supported.

Using the PivotFormulas Collection

Use the PivotFormulas method to return the PivotFormulas collection. The following example creates a list of PivotTable formulas for the first PivotTable report on the active worksheet.

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


Methods | Add Method | Item Method

Parent Objects | PivotTable

Child Objects



Show:
© 2014 Microsoft