跳到主要内容

XlDynamicFilterCriteria

Specifies the filter criterion.

Type

Enumeration

Values

  • "xlFilterAboveAverage"
  • "xlFilterAllDatesInPeriodApril"
  • "xlFilterAllDatesInPeriodAugust"
  • "xlFilterAllDatesInPeriodDecember"
  • "xlFilterAllDatesInPeriodFebruary"
  • "xlFilterAllDatesInPeriodJanuary"
  • "xlFilterAllDatesInPeriodJuly"
  • "xlFilterAllDatesInPeriodJune"
  • "xlFilterAllDatesInPeriodMarch"
  • "xlFilterAllDatesInPeriodMay"
  • "xlFilterAllDatesInPeriodNovember"
  • "xlFilterAllDatesInPeriodOctober"
  • "xlFilterAllDatesInPeriodQuarter1"
  • "xlFilterAllDatesInPeriodQuarter2"
  • "xlFilterAllDatesInPeriodQuarter3"
  • "xlFilterAllDatesInPeriodQuarter4"
  • "xlFilterBelowAverage"
  • "xlFilterLastMonth"
  • "xlFilterLastQuarter"
  • "xlFilterLastWeek"
  • "xlFilterLastYear"
  • "xlFilterNextMonth"
  • "xlFilterNextQuarter"
  • "xlFilterNextWeek"
  • "xlFilterNextYear"
  • "xlFilterThisMonth"
  • "xlFilterThisQuarter"
  • "xlFilterThisWeek"
  • "xlFilterThisYear"
  • "xlFilterToday"
  • "xlFilterTomorrow"
  • "xlFilterYearToDate"
  • "xlFilterYesterday"