Partager via


XlDynamicFilterCriteria Enumeration

Specifies the filter criterion.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Public Enumeration XlDynamicFilterCriteria
'Usage
Dim instance As XlDynamicFilterCriteria
public enum XlDynamicFilterCriteria

Members

Member name Description
xlFilterToday Filter all values related to the current date.
xlFilterYesterday Filter all values related to yesterday.
xlFilterTomorrow Filter all values related to tomorrow.
xlFilterThisWeek Filter all values related to the current week.
xlFilterLastWeek Filter all values related to last week.
xlFilterNextWeek Filter all values related to next week.
xlFilterThisMonth Filter all values related to the current month.
xlFilterLastMonth Filter all values related to last month.
xlFilterNextMonth Filter all values related to next month.
xlFilterThisQuarter Filter all values related to the current quarter.
xlFilterLastQuarter Filter all values related to last quarter.
xlFilterNextQuarter Filter all values related to next quarter.
xlFilterThisYear Filter all values related to the current year.
xlFilterLastYear Filter all values related to last year.
xlFilterNextYear Filter all values related to next year.
xlFilterYearToDate Filter all values from today until a year ago.
xlFilterAllDatesInPeriodQuarter1 Filter all dates in Quarter1.
xlFilterAllDatesInPeriodQuarter2 Filter all dates in Quarter2.
xlFilterAllDatesInPeriodQuarter3 Filter all dates in Quarter3.
xlFilterAllDatesInPeriodQuarter4 Filter all dates in Quarter4.
xlFilterAllDatesInPeriodJanuary Filter all dates in January.
xlFilterAllDatesInPeriodFebruray Filter all dates in February.
xlFilterAllDatesInPeriodMarch Filter all dates in March.
xlFilterAllDatesInPeriodApril Filter all dates in April.
xlFilterAllDatesInPeriodMay Filter all dates in May.
xlFilterAllDatesInPeriodJune Filter all dates in June.
xlFilterAllDatesInPeriodJuly Filter all dates in July.
xlFilterAllDatesInPeriodAugust Filter all dates in August.
xlFilterAllDatesInPeriodSeptember Filter all dates in September.
xlFilterAllDatesInPeriodOctober Filter all dates in October.
xlFilterAllDatesInPeriodNovember Filter all dates in November.
xlFilterAllDatesInPeriodDecember Filter all dates in December.
xlFilterAboveAverage Filter all above-average values.
xlFilterBelowAverage Filter all below-average values.

See Also

Reference

Microsoft.Office.Interop.Excel Namespace