Thread: In VBA set Slection.AutoFilter show all
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Djmask Djmask is offline
external usenet poster
  
Posts: 1
Default In VBA set Slection.AutoFilter show all

How do I set the Selection. AutoFileter Field Criteria to be "All" s
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.


Scot

--
Djmas
-----------------------------------------------------------------------
Djmask's Profile: http://www.excelforum.com/member.php...fo&userid=2441
View this thread: http://www.excelforum.com/showthread.php?threadid=39659

Reply With QuoteReply With Quote