IRange.AutoFilter Method

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

Syntax

'Declaration
Function AutoFilter ( _
    Field As Object, _
    Criteria1 As Object, _
    Operator As XlAutoFilterOperator, _
    Criteria2 As Object, _
    VisibleDropDown As Object _
) As Object
'Usage
Dim instance As IRange
Dim Field As Object
Dim Criteria1 As Object
Dim Operator As XlAutoFilterOperator
Dim Criteria2 As Object
Dim VisibleDropDown As Object
Dim returnValue As Object

returnValue = instance.AutoFilter(Field, _
    Criteria1, Operator, Criteria2, VisibleDropDown)

Object AutoFilter(
    Object Field,
    Object Criteria1,
    XlAutoFilterOperator Operator,
    Object Criteria2,
    Object VisibleDropDown
)

Parameters

• Field
  Type: System.Object

• Criteria1
  Type: System.Object

• Operator
  Type: Microsoft.Office.Interop.Excel.XlAutoFilterOperator

• Criteria2
  Type: System.Object

• VisibleDropDown
  Type: System.Object

Return Value

Type: System.Object

See Also

Reference

IRange Interface

IRange Members

Microsoft.Office.Interop.Excel Namespace