NamedRange::AutoFilter Method (Object^, Object^, XlAutoFilterOperator, Object^, Object^)
Filters a list using the AutoFilter.
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
Object^ AutoFilter( Object^ Field, Object^ Criteria1, XlAutoFilterOperator Operator = XlAutoFilterOperator::xlAnd, Object^ Criteria2, Object^ VisibleDropDown )
Parameters
- Field
-
Type:
System::Object^
The offset of the field on which you want to base the filter (from the left of the list; the leftmost field is field 1 (one)).
- Criteria1
-
Type:
System::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
Can be one of the following XlAutoFilterOperator constants:
Use xlAnd and xlOr with Criteria1 and Criteria2 to construct compound criteria.
- Criteria2
-
Type:
System::Object^
The second criteria (a string). Used with Criteria1 and Operator to construct compound criteria.
- VisibleDropDown
-
Type:
System::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.
Return Value
Type: System::Object^If you omit all the arguments, this method simply toggles the display of the AutoFilter drop-down arrows in the NamedRange control.
For information on optional parameters, see Optional Parameters in Office Solutions.