How do I control Auto Filter in VBA

[Mallycat]

I want to be able to control an autofilter from VBA.

eg say I have a table with the following headings

Animal Name Age

In the animal column, the data is either Cat or Dog.

How can I create a Macro to select Cat or Dog in the Auto Filter?

Matt

 

[Tom Ogilvy]

Selection.Autofilter Filter:=1, Criteria1:="Cat"

 

[Mallycat]

Selection.Autofilter Filter:=1, Criteria1:="Cat"

Thanks. So easy when you know how. I haven't been able to get this to
work previously.

Matt

 

[Nigel]

try using the macro recorder it will create the code you need