IAutoFilter Interface Members
In This Topic
The following tables list the members exposed by IAutoFilter.
Public Properties
| Name | Description |
 | FilterMode |
Returns True if the worksheet is in the AutoFilter filter mode (read-only).
|
 | Filters |
Returns a Filters collection that represents all the filters in an autofiltered range (read-only).
|
 | Range |
Returns a Range object that represents the range to which the specified AutoFilter applies.
|
 | Sort |
Gets the sort column or columns, and sort order for the AutoFilter collection.
|
Top
Public Methods
| Name | Description |
 | ApplyFilter |
Applies the specified AutoFilter object.
|
 | ShowAllData |
Displays all the data returned by the AutoFilter object.
|
Top
See Also