Skip to main content
Row

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