Criteria Object

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.