Filter Object

Excel Developer Reference

Represents a filter for a single column.


The Filter object is a member of the Filters collection. The Filters collection contains all the filters in an autofiltered range.


Use Filters(


), where


is the filter title or index number, to return a single Filter object. The following example sets a variable to the value of the On property of the filter for the first column in the filtered range on the Crew worksheet.

Visual Basic for Applications
  Set w = Worksheets("Crew")
If w.AutoFilterMode Then
    filterIsOn = w.AutoFilter.Filters(1).On
End If

Note that all the properties of the Filter object are read-only. To set these properties, apply autofiltering manually or using the AutoFilter method of the Range object, as shown in the following example.

Visual Basic for Applications
  Set w = Worksheets("Crew")
w.Cells.AutoFilter field:=2, Criteria1:="Crucial", _
    Operator:=xlOr, Criteria2:="Important"

See Also