AutoFilterColumn Members
In This Article
#Properties
Name | Description |
---|---|
Color |
Obtains the color filter applied to column cell values. |
Custom |
Provides access to a custom filter applied to values of column cells. |
Dynamic |
Gets the type of the dynamic filter applied to the current column. |
Filter |
Gets access to an information about values and date intervals by which to filter. |
Filter |
Gets the type of the filter applied to the current column. |
Hidden |
Gets or set a value indicating whether the Auto |
Top10Type | Returns the filter operator of the "Top 10" filter applied to a column. |
Top10Value | Returns the filter value of the "Top 10" filter applied to a column. |
#Methods
Name | Description |
---|---|
Apply |
Applies a custom filter based on the compound filter expression. |
Apply |
Applies a custom filter based on the specified filter value and comparison operator. |
Apply |
Applies a dynamic filter that shows dates that fall within a specified time period or displays values that are above or below the average. |
Apply |
Applies the background color filter. |
Apply |
Applies a filter by cell fill pattern. |
Apply |
Filters data by cell values and Date |
Apply |
Filters data by values. |
Apply |
Filters data by a list of date and time values. |
Apply |
Applies the font color filter. |
Apply |
Applies the "Top 10" filter that displays top/bottom ranked values. |
Clear() | Removes a filter from a specified column. |
See Also