Filter Object

                  Properties                 

AutoFilter object
Filters collection (Filter object)
Criteria collection (Criterion object)

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.