Edit

XlDynamicFilterCriteria enumeration (Excel)

  • Article

Specifies the filter criterion.

Name Value Description
xlFilterAboveAverage 33 Filter all above-average values.
xlFilterAllDatesInPeriodApril 24 Filter all dates in April.
xlFilterAllDatesInPeriodAugust 28 Filter all dates in August.
xlFilterAllDatesInPeriodDecember 32 Filter all dates in December.
xlFilterAllDatesInPeriodFebruary 22 Filter all dates in February.
xlFilterAllDatesInPeriodJanuary 21 Filter all dates in January.
xlFilterAllDatesInPeriodJuly 27 Filter all dates in July.
xlFilterAllDatesInPeriodJune 26 Filter all dates in June.
xlFilterAllDatesInPeriodMarch 23 Filter all dates in March.
xlFilterAllDatesInPeriodMay 25 Filter all dates in May.
xlFilterAllDatesInPeriodNovember 31 Filter all dates in November.
xlFilterAllDatesInPeriodOctober 30 Filter all dates in October.
xlFilterAllDatesInPeriodQuarter1 17 Filter all dates in Quarter1.
xlFilterAllDatesInPeriodQuarter2 18 Filter all dates in Quarter2.
xlFilterAllDatesInPeriodQuarter3 19 Filter all dates in Quarter3.
xlFilterAllDatesInPeriodQuarter4 20 Filter all dates in Quarter4.
xlFilterAllDatesInPeriodSeptember 29 Filter all dates in September.
xlFilterBelowAverage 34 Filter all below-average values.
xlFilterLastMonth 8 Filter all values related to last month.
xlFilterLastQuarter 11 Filter all values related to last quarter.
xlFilterLastWeek 5 Filter all values related to last week.
xlFilterLastYear 14 Filter all values related to last year.
xlFilterNextMonth 9 Filter all values related to next month.
xlFilterNextQuarter 12 Filter all values related to next quarter.
xlFilterNextWeek 6 Filter all values related to next week.
xlFilterNextYear 15 Filter all values related to next year.
xlFilterThisMonth 7 Filter all values related to the current month.
xlFilterThisQuarter 10 Filter all values related to the current quarter.
xlFilterThisWeek 4 Filter all values related to the current week.
xlFilterThisYear 13 Filter all values related to the current year.
xlFilterToday 1 Filter all values related to the current date.
xlFilterTomorrow 3 Filter all values related to tomorrow.
xlFilterYearToDate 16 Filter all values from today until a year ago.
xlFilterYesterday 2 Filter all values related to yesterday.

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.