PivotFormulas Collection Object [Excel 2003 VBA Language Reference]
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
Properties | Application Property | Count Property | Creator Property | Parent Property
Methods | Add Method | Item Method
Parent Objects | PivotTable
Child Objects
See Also | PivotCache Object | PivotCell Object | PivotField Object | PivotFormula Object | PivotItem Object | PivotItemList Collection | PivotLayout Object | PivotTable Object