Thread: In VBA set Slection.AutoFilter show all
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
  
Posts: 5,302
Default In VBA set Slection.AutoFilter show all
Hi Djmask,

Try:

Selection.AutoFilter Field:=12

or

ActiveSheet.AutoFilter.Range.AutoFilter field:=12

(with no criteria assignment)

---
Regards,
Norman



"Djmask" wrote in
message ...

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

Selection.AutoFilter Field:=12, Criteria1:=????

I've tried "All" and (All) but doesn't work.


Scott


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



Reply With QuoteReply With Quote