PivotFilters Object (Excel)

The PivotFilters object is a collection of PivotFilter objects.

Version Added: Excel 2007

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.

In the following example, a new PivotFilter is added to the PivotField at the currently active cell.

ActiveCell.PivotField.PivotFilters.Add FilterType := xlThisWeek