XlAutoFilterOperator Enumeration
Specifies the operator to use to associate two criteria applied by a filter.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Public Enumeration XlAutoFilterOperator
'Usage
Dim instance As XlAutoFilterOperator
public enum XlAutoFilterOperator
Members
| Member name | Description | |
|---|---|---|
| xlAnd | Logical AND of Criteria1 and Criteria2. | |
| xlBottom10Items | Lowest-valued items displayed (number of items specified in Criteria1). | |
| xlBottom10Percent | Lowest-valued items displayed (percentage specified in Criteria1). | |
| xlOr | Logical OR of Criteria1 and Criteria2. | |
| xlTop10Items | Highest-valued items displayed (number of items specified in Criteria1). | |
| xlTop10Percent | Lowest-valued items displayed (percentage of items specified in Criteria1). | |
| xlFilterValues | Filter values | |
| xlFilterCellColor | Color of the cell | |
| xlFilterFontColor | Color of the font | |
| xlFilterIcon | Filter icon | |
| xlFilterDynamic | Dynamic filter | |
| xlFilterNoFill | Reserved for internal use. | |
| xlFilterAutomaticFontColor | Reserved for internal use. | |
| xlFilterNoIcon | Reserved for internal use. |