In VBA set Slection.AutoFilter show all

[Djmask]

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

 

[Norman Jones]

Hi Djmask,

Try:

Selection.AutoFilter Field:=12

or

ActiveSheet.AutoFilter.Range.AutoFilter field:=12

(with no criteria assignment)

 

[Djmask]

Worksheets("Sheet1").ShowAllData

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

 

[Norman Jones]

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:

 

[Djmask]

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