Share via

Filter Object [Excel 2003 VBA Language Reference]

  • Article
AutoFilter
Filters
Filter

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.

Using the Filter Object

Use Filters(index), where index 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.

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.

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

Properties | Application Property | Creator Property | Criteria1 Property | Criteria2 Property | On Property | Operator Property | Parent Property

Parent Objects | AutoFilter

Child Objects