Auto Filter Object

The AutoFilter object provides the functionality equivalent to the AutoFilter feature in Excel. This object can programmatically filter a range of text for specific types of rows, hiding the rows that do not meet the filter criteria. Examples of filters include top 10 rows in the column, rows matching specific values, and non-blank cells in the row. The parent of the AutoFilter object is the Worksheet object (implying that a worksheet can have only one AutoFilter).

The AutoFilter object is used with the AutoFilter method of the Range object and the AutoFilterType property of the Worksheet object.

0 0

Post a comment