Worksheet.FilterMode Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Gets a value that indicates whether the worksheet is actively filtering data.
public:
property bool FilterMode { bool get(); };public bool FilterMode { get; }member this.FilterMode : boolPublic ReadOnly Property FilterMode As BooleanProperty Value
true if the worksheet is actively filtering data; otherwise, false.
Remarks
To determine whether filtering is currently enabled (that is, whether the filter drop-down arrows are displayed on the worksheet), use the AutoFilterMode property.
To enable filtering and create a filtered list, use the AutoFilter method of a Range object, or use the AutoFilter method of a NamedRange object.
This property is true if the worksheet contains a filtered list in which there are hidden rows.