Mark,

Don't check simply turn it off. If it isn't on it won't generate an error

Sub FilterOff()
Worksheets("sheet1").AutoFilterMode = False
End Sub

Mike

"Mark Ivey" wrote:

How can I check to see if the autofilter is on before I launch my code?

TIA

Mark Ivey