Share via


Worksheet.FilterMode Property

Definition

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 : bool
Public ReadOnly Property FilterMode As Boolean

Property 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.

Applies to