autoFilter(int,Object,AutoFilterOperator,Object,boolean) Method
In This Topic
Filters a list using the AutoFilter.
Syntax
void autoFilter(
int ,
java.lang.Object ,
AutoFilterOperator ,
java.lang.Object ,
boolean
)
|
Parameters
- field
- Optional Object. The integer offset of the field onwhich you want to base the filter (from the left of the list; the leftmost field is field zero).
- criteria1
- Optional Object. The criteria (a string; for example,"101"). Use "=" to find blank fields, or use " @literal:<>" 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). Usedwith Criteria1 and Operator to construct compound criteria.
- visibleDropDown
- Optional Object. True to display the AutoFilterdrop-down arrow for the filtered field; False to hide the AutoFilter drop-down arrow for the filtered field. True by default.
See Also