1 out of 2 rated this helpful - Rate this topic

Range.AutoFilter Method

Office 2010

Filters a list using the AutoFilter.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Object AutoFilter(
	Object Field,
	Object Criteria1,
	XlAutoFilterOperator Operator,
	Object Criteria2,
	Object VisibleDropDown
)

Field: Type: System.Object
Optional Object. 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: Type: System.Object
Optional Object. 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

Type: Microsoft.Office.Interop.Excel.XlAutoFilterOperator

Optional XlAutoFilterOperator. Can be one of the following XlAutoFilterOperator constants:

Use xlAnd and xlOr with Criteria1 and Criteria2 to construct compound criteria.

Criteria2: Type: System.Object
Optional Object. The second criteria (a string). Used with Criteria1 and Operator to construct compound criteria.

VisibleDropDown: Type: System.Object
Optional Object. 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.

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

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

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions