Autofilter Macro Help

[RonB]

Is there a macro statement I can use that will set the AutoFilter condition
to OFF regardless of teh current state it is in?

 

[Max]

Maybe try the snippet below, copied from Debra's:
http://www.contextures.com/xlautofilter03.html

Turn Off AutoFilter

Use the following code to turn off an AutoFilter, if one exists

Sub TurnFilterOff()
'removes AutoFilter if one exists
Worksheets("Data").AutoFilterMode = False
End Sub