PivotField.ClearValueFilters Method
| Excel Developer Reference |
Calling this method deletes all value filters in the PivotFilters collection of the PivotField.
Version Information
Version Added: Excel 2007
Syntax
expression.ClearValueFilters
expression A variable that represents a PivotField object.
Remarks
The following table lists the different value filter types that will be deleted by this method.
| xlTopCount |
| xlBottomCount |
| xlTopPercent |
| xlBottomPercent |
| xlTopSum |
| xlBottomSum |
| xlValueEquals |
| xlValueDoesNotEqual |
| xlValueIsGreaterThan |
| xlValueIsGreaterThanOrEqualTo |
| xlValueIsLessThan |
| xlValueIsLessThanOrEqualTo |
| xlValueIsBetween |
| xlValueIsNotBetween |
See Also