Excel.Worksheet.FilterMode.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Worksheet.FilterMode property (Excel)	vbaxl10.chm175100	vbaxl10.chm175100	Excel.Worksheet.FilterMode	d9bcaa8a-caf3-96a4-445d-d957a987b057	05/30/2019	medium

Worksheet.FilterMode property (Excel)

True if the worksheet is in the filter mode. Read-only Boolean.

Syntax

expression.FilterMode

expression A variable that represents a Worksheet object.

Example

In the following example, the code returns True if the worksheet is in the filter mode.

Dim Worksheet1 As Worksheet 
 
Dim returnValue As Boolean 
returnValue = Worksheet1.FilterMode

[!includeSupport and feedback]