AutoFilterMode Property (Worksheet)

In This Topic

Gets a value that indicates whether the AutoFilter drop-down arrows are currently displayed on the sheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Property AutoFilterMode As Boolean

'Usage
 
Dim instance As Worksheet
Dim value As Boolean
 
instance.AutoFilterMode = value
 
value = instance.AutoFilterMode

public bool AutoFilterMode {get; set;}

Property Value

true if the AutoFilter drop-down arrows are currently displayed on the sheet; otherwise, false.

Remarks

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 IRange.AutoFilter method to filter a list and display the drop-down arrows.

Reference

Worksheet Class
Worksheet Members

Product Support Forum | Print this page