TableAutoFilter Members
An object implementing the filtering functionality for the specified table.Properties
| Name | Description |
|---|---|
| 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() | Enables the filtering functionality for the specified table. |
| 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