Unfilter

[JohnUK]

Hi again
First of all I would like to thank everyone that has
helped me so far,the responses have been fast and very
helpful
Now for my next question : Can anyone give me a code that
I can use that would set all filters to unfilter
regardles of anything being filtered or not - I think I
understood that.
Many thanks in advance

 

[Ron de Bruin]

Hi JohnUK

ActiveSheet.AutoFilterMode = False

For AutoFilter

If you use AdvancedFilter

On Error Resume Next
ActiveSheet.ShowAllData
On Error GoTo 0

 

[JohnUK]

Many Thanks Ron
By the way your emailing "Stuff" was a fantastic help
The only thing I havn't been able to sort out yet is the
Zipping of a file in XP
Regards
John

-----Original Message-----
Hi JohnUK

ActiveSheet.AutoFilterMode = False

For AutoFilter

If you use AdvancedFilter

On Error Resume Next
ActiveSheet.ShowAllData
On Error GoTo 0



--
Regards Ron de Bruin
http://www.rondebruin.nl


"JohnUK" <[email protected]> wrote in

message news:[email protected]...