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

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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"RonB" wrote in message
...
Is there a macro statement I can use that will set the AutoFilter
condition
to OFF regardless of teh current state it is in?
--
RonB