Filter Object

Remarks

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

Example

Use Filters(), where is the filter title or index number, to return a single Filterobject. The following example sets a variable to the value of the Onproperty 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"

See also:

• Excel Object Model Reference
• Filter Object Members