Expand Minimize

Worksheet.FilterMode Property

Gets a value that indicates whether the worksheet is actively filtering data.

Namespace:  Microsoft.Office.Tools.Excel
Assemblies:   Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

bool FilterMode { get; }

Property Value

Type: System.Boolean
true if the worksheet is actively filtering data; otherwise, false.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2015 Microsoft