[]
Represents autofiltering for the specified worksheet.
public interface IAutoFilter
Public Interface IAutoFilter
| 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. |
| Name | Description |
|---|---|
| ApplyFilter() | Applies the specified AutoFilter object. |
| ShowAllData() | Displays all the data returned by the AutoFilter object. |