Hi Djmask,

Worksheets("Sheet1").ShowAllData

I figured it out. Incase anyone else is looking. Amazing what you can
find in the manual.

This wiil remove all filters, not the single field filter which appeared to
be your object from the originally posed question:

How do I set the Selection. AutoFileter Field Criteria to be "All" so
there are no filters on that Column. Thanks for your help

---
Regards,
Norman



"Djmask" wrote in
message ...

Worksheets("Sheet1").ShowAllData

I figured it out. Incase anyone else is looking. Amazing what you can
find in the manual.


--
Djmask
------------------------------------------------------------------------
Djmask's Profile:
http://www.excelforum.com/member.php...o&userid=24414
View this thread: http://www.excelforum.com/showthread...hreadid=396599