PivotFilters Object (Excel)

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

The PivotFilters object is a collection of PivotFilter objects.

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