Filter Object

Multiple objects Filter Multiple objects

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.

Properties | Application Property | Criteria Property | Parent Property

Parent Objects | Criteria Object | Filters Collection

Child Objects | AutoFilter Object | Criteria Object