View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Mark Ivey Mark Ivey is offline
external usenet poster
 
Posts: 120
Default Autofilter Check

Thanks for the advice....

I will give it a shot.

Mark

"Mike H" wrote in message
...
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