AutoFilter Methods

The AutoFilter type exposes the following members.

Methods
  NameDescription
Public methodAddDateFilter
Adds a date filter.
Public methodAddFillColorFilter
Adds a fill color filter.
Public methodAddFilter
Adds a filter for a filter column.
Public methodAddFontColorFilter
Adds a font color filter.
Public methodAddIconFilter
Adds an icon filter.
Public methodCustom(Int32, FilterOperatorType, Object)
Filters a list with a custom criteria.
Public methodCustom(Int32, FilterOperatorType, Object, Boolean, FilterOperatorType, Object)
Filters a list with custom criteria.
Public methodDynamicFilter
Adds a dynamic filter.
Public methodEquals (Inherited from Object.)
Public methodFilter
Filters a list with specified criteria.
Public methodFilterTop10
Filter the top 10 item in the list
Protected methodFinalize (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Public methodMatchBlanks
Match all blank cell in the list.
Public methodMatchNonBlanks
Match all not blank cell in the list.
Protected methodMemberwiseClone (Inherited from Object.)
Public methodRefresh
Refresh auto filters to hide or unhide the rows.
Public methodRefresh(Boolean)
Gets all hidden rows' indexes.
Public methodRemoveDateFilter
Removes a date filter.
Public methodRemoveFilter(Int32)
Remove the specific filter.
Public methodRemoveFilter(Int32, String)
Removes a filter for a filter column.
Public methodSetRange
Sets the range to which the specified AutoFilter applies.
Public methodShowAll
Unhide all rows.
Public methodToString (Inherited from Object.)
See Also