Hi,

The simplest way and because of the lack of detail in the question would be
for you to record a macro of yourself doing it or you may be able to build on
this

Range("A1").AutoFilter Field:=1, Criteria1:="JohnDoe"

Mike

"Rhoswen" wrote:

Is it possible to write a macro that will do an AutoFilter? I need a macro
that will autofilter the same column for the same criteria every time.

Anybody?