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

--
Regards,
Tom Ogilvy

"Mallycat" wrote in
message ...

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


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile:
http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=552982