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

Filter Criteria

Contains the entire array of AutoFilter criteria. Each criterion is a String value. 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 Criteria Object

The Filter object’s Criteria property returns the Criteria object for the specified filter.