Share via

PivotFormula Object Members

  • Article
Excel Developer Reference

Represents a formula used to calculate results in a PivotTable report.

Methods

  Name Description
Bb256085.methods(en-us,office.12).gif Delete Deletes the object.

Properties

  Name Description
Bb256085.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Bb256085.properties(en-us,office.12).gif Formula Returns or sets a String value that represents the object's formula in A1-style notation and in the language of the macro.
Bb256085.properties(en-us,office.12).gif Index Returns or sets a Long value that represents the index number of the PivotFormula object within the PivotFormulas collection.
Bb256085.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb256085.properties(en-us,office.12).gif StandardFormula Returns or sets a String specifying formulas with standard English (United States) formatting. Read/write.
Bb256085.properties(en-us,office.12).gif Value Returns or sets a String value that represents the name of the specified formula in the PivotTable formula.