I want Cell content as Autofilter criteria
 

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

I want Cell content as Autofilter criteria
 

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

I want Cell content as Autofilter criteria
 

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