LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
display cell content based on date criteria hsg Excel Discussion (Misc queries) 2 December 2nd 09 05:37 PM
Multiple criteria in autofilter BASFMark Excel Worksheet Functions 1 December 11th 08 06:38 PM
Autofilter - Supply Criteria JMay Excel Discussion (Misc queries) 2 January 2nd 07 01:29 PM
Displaying autofilter criteria [email protected] Excel Worksheet Functions 0 February 25th 05 09:41 PM
VBA Autofilter Criteria Brandon[_5_] Excel Programming 1 November 7th 03 12:40 PM


All times are GMT +1. The time now is 05:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"