Amazon VBA User Manual

283
Using New Pivot Table Features in Excel 2007
xlDateNextMonth Filters for all dates that apply to the next month
xlDateNextQuarter Filters for all dates that apply to the next quarter
xlDateNextWeek Filters for all dates that apply to the next week
xlDateNextYear Filters for all dates that apply to the next year
xlDateThisMonth Filters for all dates that apply to the current
month
xlDateThisQuarter Filters for all dates that apply to the current
quarter
xlDateThisWeek Filters for all dates that apply to the current
week
xlDateThisYear Filters for all dates that apply to the current year
xlDateToday Filters for all dates that apply to the current date
xlDateTomorrow Filters for all dates that apply to the next day
xlDateYesterday Filters for all dates that apply to the previous
day
xlNotSpecificDate Filters for all dates that do not match a specified
date
xlSpecificDate Filters for all dates that match a specified date
xlTopCount Filters for the specified number of values from
the top of a list
xlTopPercent Filters for the specified percentage of values
from a list
xlTopSum Sums the values from the top of the list
xlValueDoesNotEqual Filters for all values that do not match the speci-
fied value
xlValueEquals Filters for all values that match the specified
value
xlValueIsBetween Filters for all values that are between a specified
range of values
xlValueIsGreaterThan Filters for all values that are greater than the
specified value
xlValueIsGreaterThanOrEqualTo Filters for all values that are greater than or
match the specified value
xlValueIsLessThan Filters for all values that are less than the
specified value
xlValueIsLessThanOrEqualTo Filters for all values that are less than or match
the specified value
11
Filter Type Description
continues
12_0789736012_CH11.qxd 12/11/06 6:26 PM Page 283

Amazon VBA Specifications

General

Brand	Amazon
Model	VBA
Category	Software
Language	English