SheetAutoFilter Members
An object implementing the filtering functionality for the specified worksheet.Properties
| Name | Description |
|---|---|
| AllowExpand | Gets whether the auto filtering is expanded to the worksheet’s data range. |
| Columns | Gets a collection of filters for columns. Inherited from AutoFilterBase. |
| Enabled | Gets whether the filtering functionality is enabled. Inherited from AutoFilterBase. |
| Range | Returns the range to which the filter is applied. Inherited from AutoFilterBase. |
| SortState | Provides access to an interface that allows you to specify sort conditions and perform sorting. Inherited from AutoFilterBase. |
Methods
| Name | Description |
|---|---|
| Apply(CellRange, Boolean) | Enables the filtering functionality for the specified cell range. |
| Apply(CellRange) | Enables the filtering functionality for the specified range of cells. |
| Clear() | Removes all the filters specified in a worksheet and displays all hidden rows. Inherited from AutoFilterBase. |
| Disable() | Turns off the filtering functionality. Inherited from AutoFilterBase. |
| ReApply() | Reapplies a filter. Inherited from AutoFilterBase. |
See Also