Share via

PivotFormulas.Add Method

  • Article

Creates a new PivotTable formula. Returns a PivotFormula object.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Function Add ( _
    Formula As String, _
    UseStandardFormula As Object _
) As PivotFormula
'Usage
Dim instance As PivotFormulas
Dim Formula As String
Dim UseStandardFormula As Object
Dim returnValue As PivotFormula

returnValue = instance.Add(Formula, UseStandardFormula)

PivotFormula Add(
    string Formula,
    Object UseStandardFormula
)

Parameters

  • Formula
    Type: System.String

    Required String. The new PivotTable formula.

  • UseStandardFormula
    Type: System.Object

    Optional Object. A standard PivotTable formula.

Return Value

Type: Microsoft.Office.Interop.Excel.PivotFormula

See Also

Reference

PivotFormulas Interface

PivotFormulas Members

Microsoft.Office.Interop.Excel Namespace