This documentation is archived and is not being maintained.

AutoFilter Method [Excel 2003 VBA Language Reference]

Office 2003

Filters a list using the AutoFilter. Variant.

Note   Apply the AutoFilter property to a Worksheet object to return an AutoFilter object.

expression .AutoFilter(Field, Criteria1, Operator, Criteria2, VisibleDropDown)

expression Required. An expression that returns one of the objects in the Applies To list.

Field   Optional Variant. The integer offset of the field on which you want to base the filter (from the left of the list; the leftmost field is field one).

Criteria1   Optional Variant. The criteria (a string; for example, "101"). Use "=" to find blank fields, or use "<>" to find nonblank fields. If this argument is omitted, the criteria is All. If Operator is xlTop10Items, Criteria1 specifies the number of items (for example, "10").

XlAutoFilterOperator can be one of these XlAutoFilterOperator constants.
xlAnd default
Use xlAnd and xlOr with Criteria1 and Criteria2 to construct compound criteria.

Criteria2   Optional Variant. The second criteria (a string). Used with Criteria1 and Operator to construct compound criteria.

VisibleDropDown   Optional Variant. True to display the AutoFilter drop-down arrow for the filtered field. False to hide the AutoFilter drop-down arrow for the filtered field. True by default.


If you omit all the arguments, this method simply toggles the display of the AutoFilter drop-down arrows in the specified range.


This example filters a list starting in cell A1 on Sheet1 to display only the entries in which field one is equal to the string "Otis". The drop-down arrow for field one will be hidden.

Worksheets("Sheet1").Range("A1").AutoFilter _
    field:=1, _

Applies to | Range Collection

See Also | AdvancedFilter Method | AutoFilter Method | AutoFilter Object | AutoFilterMode Property | FilterMode Property | ShowAllData Method