This documentation is archived and is not being maintained.

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)

'Usage
Dim xlAutoFilterOperator1 As XlAutoFilterOperator = XlAutoFilterOperator.xlAnd

public enum XlAutoFilterOperator
public enum XlAutoFilterOperator
public enum XlAutoFilterOperator

Member nameDescription
xlAndLogical AND of Criteria1 and Criteria2.
xlBottom10ItemsLowest-valued items displayed (number of items specified in Criteria1).
xlBottom10PercentLowest-valued items displayed (percentage specified in Criteria1).
xlOrLogical OR of Criteria1 and Criteria2.
xlTop10ItemsHighest-valued items displayed (number of items specified in Criteria1).
xlTop10PercentLowest-valued items displayed (percentage of items specified in Criteria1).

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms

Show: