Szerkesztés

Megosztás a következőn keresztül:


XlAutoFilterOperator enumeration (Excel)

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)

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.