Sub bbb()
For Each sh In Worksheets
If sh.FilterMode Then
sh.ShowAllData
End If
Next
End Sub

is possibly what you want.

--
Regards,
Tom Ogilvy


"Timmy Mac1" wrote
in message ...

Apologies in advance because I know this is probably quite basic stuff
here...

I want to get a macro that releases all filters in all worksheets, but
I don't know how to get around the fact that a filter might not be
showing or set up for a particular sheet.

I'd appreciate any help to construct the necessary statement to get
around this.

thanks

tt


--
Timmy Mac1
------------------------------------------------------------------------
Timmy Mac1's Profile:
http://www.excelforum.com/member.php...o&userid=15188
View this thread: http://www.excelforum.com/showthread...hreadid=514843