Edit

PjAutoFilterType enumeration (Project)

  • Article

Contains constants that specify how to set the automatic filter.

Name Value Description
pjAutoFilter1DayOrLess 22 Filter for items that are one day or shorter.
pjAutoFilter1WeekOrLonger 24 Filter for items that are one week or longer.
pjAutoFilter40HoursOrMore 28 Filter for 40 hours or more.
pjAutoFilter8HoursOrLess 26 Filter for items that are eight hours or less.
pjAutoFilterAfterStatusDate 20 Filter for items that occur after the project status date.
pjAutoFilterBeforeStatusDate 19 Filter for items that occur before the project status date.
pjAutoFilterBeginsWith 45 Filter for items that begin with a specified value.
pjAutoFilterBetween 44 Filter for items that are between specified values.
pjAutoFilterBetween1DayAnd1Week 23 Filter for items between one day and one week.
pjAutoFilterBetween8And40Hours 27 Filter for items between eight hours and 40 hours.
pjAutoFilterClear 0 Clear the autofilter.
pjAutoFilterComplete 32 The autofilter is complete.
pjAutoFilterContains 47 Filter for values that contain a specified value.
pjAutoFilterCustom 1 Use a custom autofilter.
pjAutoFilterEndsWith 46 Filter for items that end with a specified value.
pjAutoFilterEquals 40 Filter for items that equal a specified value.
pjAutoFilterFlagNo 39 Filter for items with a flag value of No.
pjAutoFilterFlagYes 38 Filter for items with a flag value of Yes.
pjAutoFilterGreaterThan 42 Filter for items greater than a specified value.
pjAutoFilterGreaterThan0Cost 37 Filter for items greater than zero cost.
pjAutoFilterIn 2 Filter for items within a specified value.
pjAutoFilterInProgress 31 Filter for items that are in progress.
pjAutoFilterLastMonth 11 Filter for items within the last month.
pjAutoFilterLastQuarter 14 Filter for items within the last quarter.
pjAutoFilterLastWeek 8 Filter for items within the last week.
pjAutoFilterLastYear 17 Filter for items within the last year.
pjAutoFilterLessThan 43 Filter for items less than a specified value.
pjAutoFilterNextMonth 9 Filter for items within the next month.
pjAutoFilterNextQuarter 12 Filter for items within the next quarter.
pjAutoFilterNextWeek 6 Filter for items within the next week.
pjAutoFilterNextYear 15 Filter for items within the next year.
pjAutoFilterNoDate 21 Filter for items that have no date.
pjAutoFilterNoDuration 25 Filter for items that have no duration.
pjAutoFilterNotContains 48 Filter for items that don't contain the specified value.
pjAutoFilterNotEquals 41 Filter for items that don't equal the specified value.
pjAutoFilterNotStarted 30 Filter for items that are not started.
pjAutoFilterNoWork 29 Filter for items that contain no work.
pjAutoFilterPhonetic0 49 Filter for items that have the base phonetic value.
pjAutoFilterPhonetic1 50 Filter for items that have the first phonetic value.
pjAutoFilterPhonetic10 59 Filter for items that have the tenth phonetic value.
pjAutoFilterPhonetic2 51 Filter for items that have the second phonetic value.
pjAutoFilterPhonetic3 52 Filter for items that have the third phonetic value.
pjAutoFilterPhonetic4 53 Filter for items that have the fourth phonetic value.
pjAutoFilterPhonetic5 54 Filter for items that have the fifth phonetic value.
pjAutoFilterPhonetic6 55 Filter for items that have the sixth phonetic value.
pjAutoFilterPhonetic7 56 Filter for items that have the seventh phonetic value.
pjAutoFilterPhonetic8 57 Filter for items that have the eighth phonetic value.
pjAutoFilterPhonetic9 58 Filter for items that have the ninth phonetic value.
pjAutoFilterThisMonth 10 Filter for items that occur this month.
pjAutoFilterThisQuarter 13 Filter for items that occur this quarter.
pjAutoFilterThisWeek 7 Filter for items that occur this week.
pjAutoFilterThisYear 16 Filter for items that occur this year.
pjAutoFilterToday 3 Filter for items that occur today.
pjAutoFilterTomorrow 4 Filter for items that occur tomorrow.
pjAutoFilterWithin1And25Percent 33 Filter for items that are within one percent and 25 percent.
pjAutoFilterWithin26And50Percent 34 Filter for items that are within 26 percent and 50 percent.
pjAutoFilterWithin51And75Percent 35 Filter for items that are within 51 percent and 75 percent.
pjAutoFilterWithin76And100Percent 36 Filter for items that are within 76 percent and 100 percent.
pjAutoFilterYearToDate 18 Filter for items that occur within the year to date.
pjAutoFilterYesterday 5 Filter for items that occur 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.