My SpreadSheet Magic

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.

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

Example

This example displays the current status of the AutoFilterMode property on Sheet1.

Sub TestFilter()

If Worksheets("Sheet1").AutoFilterMode Then

isOn = "On"

Else

isOn = "Off"

End If

MsgBox "AutoFilterMode is " & isOn

End Sub

For more info. visit Microsoft MSDN Section.

posted by Noel J @ 4:54 PM