AutoFilter(Int32,Object,AutoFilterOperator,Object) Method

In This Topic

Filters a list using the AutoFilter.

Syntax

Visual Basic
C#

'Declaration
 
Overloads Function AutoFilter( _
   ByVal columnIndex As Integer, _
   Optional ByVal criteria1 As Object, _
   Optional ByVal filterOperator As AutoFilterOperator, _
   Optional ByVal criteria2 As Object _
) As Boolean

'Usage
 
Dim instance As IRange
Dim columnIndex As Integer
Dim criteria1 As Object
Dim filterOperator As AutoFilterOperator
Dim criteria2 As Object
Dim value As Boolean
 
value = instance.AutoFilter(columnIndex, criteria1, filterOperator, criteria2)

bool AutoFilter( 
   int columnIndex,
   object criteria1,
   AutoFilterOperator filterOperator,
   object criteria2
)

Parameters

columnIndex: Index of the column.
criteria1: The first criteria is corresponding the first filter criteria.
filterOperator: The value specifying the type of filter.
criteria2: The second criteria is corresponding the second filter criteria.

Remarks

If is AutoFilterOperator.FilterValues, can be string[] or DateGroupItem[] array.

Reference

IRange Interface
IRange Members
Overload List