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. |
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.