This documentation is archived and is not being maintained.

_Worksheet.AutoFilterMode Property 

True if the AutoFilter drop-down arrows are currently displayed on the sheet. This property is independent of the FilterMode property. Read/write Boolean.

Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in

Dim _Worksheet1 As _Worksheet

Dim returnValue As Boolean
returnValue = _Worksheet1.AutoFilterMode

Dim sampleValue As Boolean
_Worksheet1.AutoFilterMode = sampleValue

bool AutoFilterMode {get; set;}
public boolean get_AutoFilterMode();
public void set_AutoFilterMode(boolean);
function get AutoFilterMode() : Boolean;
function set AutoFilterMode(Boolean);

This property returns True if the drop-down arrows are currently displayed. You can set this property to False to remove the arrows, but you cannot set it to True. Use the AutoFilter method to filter a list and display the drop-down arrows.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms