PivotFormulas.Add Method
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.StringRequired String. The new PivotTable formula.
UseStandardFormula
Type: System.ObjectOptional Object. A standard PivotTable formula.
Return Value
Type: Microsoft.Office.Interop.Excel.PivotFormula