Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. To ensure that the worksheet AutoFilter is turned off
Sub fileterAuto()
     If ActiveSheet.AutoFilterMode Then
         ActiveSheet.autoFilter.range.autoFilter
     End If
End Sub