Yes, use the AutoFilter method of the Range object. If you had told us more,
we could have actually constructed the statement for you. Since you didn't,
you will have to look the AutoFilter method up in the help files.

--
Rick (MVP - Excel)


"Rhoswen" wrote in message
...
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?