Criteria Object

Filter Criteria Filter

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.

Properties | Application Property | Count Property | FilterFunction Property | Item Property | Parent Property | ShowAll Property

Methods | Add Method

Parent Objects | Filter Object

Child Objects | Filter Object