Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

To ensure that the worksheet AutoFilter is turned off

Sub fileterAuto()      If ActiveSheet.AutoFilterMode Then          ActiveSheet.autoFilter.range.autoFilter      End If End Sub