XlDynamicFilterCriteria enumeration (Excel)
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.