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

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

In VBA set Slection.AutoFilter show all
 

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

In VBA set Slection.AutoFilter show all
 

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

In VBA set Slection.AutoFilter show all
 

Thanks Norman. That is actually what I needed to do I just didn't
realize it at the time.


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