Filter 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.

Filters Filter Criteria

Represents a single filter used with the AutoFilter. The Filter object is a member of the Filters collection. 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 Filter Object

The Filters object's Item property returns a Filter object.