Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
display cell content based on date criteria | Excel Discussion (Misc queries) | |||
Multiple criteria in autofilter | Excel Worksheet Functions | |||
Autofilter - Supply Criteria | Excel Discussion (Misc queries) | |||
Displaying autofilter criteria | Excel Worksheet Functions | |||
VBA Autofilter Criteria | Excel Programming |