View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CLR CLR is offline
external usenet poster
 
Posts: 594
Default 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