XlAutoFilterOperator Enumeration (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Specifies the operator to use to associate two criteria applied by a filter.

Name

Value

Description

xlAnd

1

Logical AND of Criteria1 and Criteria2.

xlBottom10Items

4

Lowest-valued items displayed (number of items specified in Criteria1).

xlBottom10Percent

6

Lowest-valued items displayed (percentage specified in Criteria1).

xlFilterCellColor

8

Color of the cell

xlFilterDynamic

11

Dynamic filter

xlFilterFontColor

9

Color of the font

xlFilterIcon

10

Filter icon

xlFilterValues

7

Filter values

xlOr

2

Logical OR of Criteria1 or Criteria2.

xlTop10Items

3

Highest-valued items displayed (number of items specified in Criteria1).

xlTop10Percent

5

Highest-valued items displayed (percentage specified in Criteria1).

Show: