Mike,

Not really much more detail to offer. It's as simple as it seems. You're
code is exactly what I needed to build on. Thanks!

"Mike H" wrote:

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?