Download Using VBA to Create Pivot Tables

12_0789736012_CH11.qxd
282
Chapter 11
12/11/06
6:26 PM
Page 282
Using VBA to Create Pivot Tables
Table 11.3 Continued
11
Filter Type
Description
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 specified 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