Filters Collection Object

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

AutoFilter Filters Filter

Represents the collection of filters used with the AutoFilter. Each filter is represented by a Filter object. The AutoFilter object contains a Filters collection, the Filters collection contains a Filter object for each column in the filtered range, and each Filter object contains a Criteria object.

Using the Filters Object

The AutoFilter object’s Filters property returns a Filters collection.