Expand Minimize
1 out of 2 rated this helpful - Rate this topic

Range.AutoFilter Method (Excel)

Filters a list using the AutoFilter.

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

expression An expression that returns a Range object.

Parameters

Name

Required/Optional

Data Type

Description

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").

Operator

Optional

XlAutoFilterOperator

One of the constants of XlAutoFilterOperator specifying the type of filter.

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.

Return Value

Variant

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, _ 
 Criteria1:="Otis", _ 
 VisibleDropDown:=False

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.