Skip to main content
Row

AutoFilterBase Members

Base interface for objects which implement filtering functionality in a worksheet and tables.

Properties

Name Description
Columns Gets a collection of filters for columns.
Enabled Gets whether the filtering functionality is enabled.
Range Returns the range to which the filter is applied.
SortState Provides access to an interface that allows you to specify sort conditions and perform sorting.

Methods

Name Description
Clear() Removes all the filters specified in a worksheet and displays all hidden rows.
Disable() Turns off the filtering functionality.
ReApply() Reapplies a filter.
See Also