AutoFilter Object

                  Properties         Methods        

Worksheet object
AutoFilter object
Filters collection (Filter object)

Represents the AutoFilter container. 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 AutoFilter Object

The Worksheet object’s AutoFilter property returns the AutoFilter object for the specified worksheet.