Skip to main content
Row

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