Share via


IPivotFilters.Add Method

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

Syntax

'Declaration
Function Add ( _
    Type As XlPivotFilterType, _
    DataField As Object, _
    Value1 As Object, _
    Value2 As Object, _
    Order As Object, _
    Name As Object, _
    Description As Object, _
    MemberPropertyField As Object _
) As PivotFilter
'Usage
Dim instance As IPivotFilters
Dim Type As XlPivotFilterType
Dim DataField As Object
Dim Value1 As Object
Dim Value2 As Object
Dim Order As Object
Dim Name As Object
Dim Description As Object
Dim MemberPropertyField As Object
Dim returnValue As PivotFilter

returnValue = instance.Add(Type, DataField, _
    Value1, Value2, Order, Name, Description, _
    MemberPropertyField)
PivotFilter Add(
    XlPivotFilterType Type,
    Object DataField,
    Object Value1,
    Object Value2,
    Object Order,
    Object Name,
    Object Description,
    Object MemberPropertyField
)

Parameters

Return Value

Type: Microsoft.Office.Interop.Excel.PivotFilter

See Also

Reference

IPivotFilters Interface

IPivotFilters Members

Microsoft.Office.Interop.Excel Namespace