Filters a list using the AutoFilter.
Syntax
void AutoFilter(
System.int ,
System.object ,
AutoFilterOperator ,
System.object ,
System.bool
)
Parameters
- field
-
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
- 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").
- op
- Optional AutoFilterOperator
- criteria2
-
Optional Object. The second criteria (a string). Used with Criteria1 and Operator to construct compound criteria.
- visibleDropDown
-
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.
See Also