So cool Tom.......that works "fine as frog hair"...........you ARE the
MAN!!!

Thanks muchly,
Vaya con Dios,
Chuck, CABGx3



"Tom Ogilvy" wrote in message
...
Criteria1:="100"

to

Criteria1:="" & worksheets("Sheet1").Range("A1").Value

--
Regards,
Tom Ogilvy

CLR wrote in message
...
Hi All.......

I can easily record a macro to start the AutoFilter function and set up
the
fields and criteria I want to filter.......but those criteria (on e for
each
of three fields) become hard-coded into the macro. What I would like to
do,
is to have the criteria respond to a value typed in a particular cell,
and
be able to change that cell and then run the macro and it will respond
to
that new criteria........is that possible?

TIA
Vaya con Dios,
Chuck, CABGx3