PivotFilters Object (Excel)
The PivotFilters object is a collection of PivotFilter objects.
Version Information
Version Added: Excel 2007
Remarks
The PivotFilters collection contains properties and methods to add new filters, count the number of existing filters in the collection, and reference specific PivotFilter objects.
Example
In the following example, a new PivotFilter is added to the PivotField at the currently active cell.
ActiveCell.PivotField.PivotFilters.Add FilterType := xlThisWeek