Search
AutoFilter Members
Methods
 


Represents autofiltering inside a worksheet.

The following tables list the members exposed by the AutoFilter type.

 Public Methods

  Name Description

applyFilter

Applies the autofilter.

getFilters

Gets a read-only collection with the filters of the individual columns.

getOn

Gets a value indicating whether at least one of the filters is active.

getRange

Gets the cell range this filter is applied to.

showAllData

Displays all the data in the autofilter range.

 See Also