SetAutoFilter

Adds an AutoFilter to the current range.

Syntax

expression.SetAutoFilter(Field, Criteria1, Operator, Criteria2, VisibleDropDown);

expression - A variable that represents a ApiRange class.

Name	Required/Optional	Data type	Default	Description
Field	Required	number		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	Required	string	string[]	ApiColor
Operator	Required	XlAutoFilterOperator		An XlAutoFilterOperator constant specifying the type of filter.
Criteria2	Required	string		The second criteria (a string). Used with Criteria1 and Operator to construct compound criteria.
VisibleDropDown	Required	boolean		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.

This method doesn't return any data.