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

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

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


.