Auto Filters on/off

[pgarcia]

I have the following code: ActiveSheet.ShowAllData
what is the code to indicate if the auto filter is not on to keep running
the rest of the VB code?

thanks

 

[Dave Peterson]

with Activesheet
if .filtermode then
.showalldata
end if
end with

 

[pgarcia]

Never mind, just found what I was looking for.

With ActiveSheet
If .FilterMode Then
.ShowAllData
End If
End With

 

[pgarcia]

Cool, thanks. I found a post that you wrote back in 2004 with that same code.
Thanks

 

[Dave Peterson]

Some questions (and answers!) don't change <vbg>.

Cool, thanks. I found a post that you wrote back in 2004 with that same code.
Thanks