Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. 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