Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

The AutoFilter object only exists when the AutoFilter feature is turned on You can determine whether the Worksheet AutoFilter is act

Sub filter()      If ActiveSheet.AutoFilterMode Then         MsgBox "Turned on"      End If End Sub