xlCaptionContains Filters for all captions that contain the specified
string
xlCaptionDoesNotBeginWith Filters for all captions that do not begin with
the specified string
xlCaptionDoesNotContain Filters for all captions that do not contain the
specified string
xlCaptionDoesNotEndWith Filters for all captions that do not end with the
specified string
xlCaptionDoesNotEqual Filters for all captions that do not match the
specified string
xlCaptionEndsWith Filters for all captions that end with the speci-
fied string
xlCaptionEquals Filters for all captions that match the specified
string
xlCaptionIsBetween Filters for all captions that are between a
specified range of values
xlCaptionIsGreaterThan Filters for all captions that are greater than the
specified value
xlCaptionIsGreaterThanOrEqualTo Filters for all captions that are greater than or
match the specified value
xlCaptionIsLessThan Filters for all captions that are less than the
specified value
xlCaptionIsLessThanOrEqualTo Filters for all captions that are less than or
match the specified value
xlCaptionIsNotBetween Filters for all captions that are not between a
specified range of values
xlDateBetween Filters for all dates that are between a specified
range of dates
xlDateLastMonth Filters for all dates that apply to the previous
month
xlDateLastQuarter Filters for all dates that apply to the previous
quarter
xlDateLastWeek Filters for all dates that apply to the previous
week
xlDateLastYear Filters for all dates that apply to the previous
year
Chapter 11 Using VBA to Create Pivot Tables
282
11
Table 11.3 Continued
Filter Type Description
12_0789736012_CH11.qxd 12/11/06 6:26 PM Page 282
To Next Page
Loading...
Need help?
General
