| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto filter macro
In using the auto filter (Selection.AutoFilter Field:=2, Criteria1:="<") in
a macro is it possible to have the "Criteria1" value equal the value of a cell (eg. F3) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
auto filter macro
Hi Larry,
Try something like: Selection.AutoFilter Field:=2, _ Criteria1:=Range("F3").Value --- Regards, Norman "Larry" wrote in message ... In using the auto filter (Selection.AutoFilter Field:=2, Criteria1:="<") in a macro is it possible to have the "Criteria1" value equal the value of a cell (eg. F3) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
auto filter macro
Thank you that worked just fine.
"Norman Jones" wrote: Hi Larry, Try something like: Selection.AutoFilter Field:=2, _ Criteria1:=Range("F3").Value --- Regards, Norman "Larry" wrote in message ... In using the auto filter (Selection.AutoFilter Field:=2, Criteria1:="<") in a macro is it possible to have the "Criteria1" value equal the value of a cell (eg. F3) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| auto filter within a macro | Excel Discussion (Misc queries) | |||
| Auto-Filter within a Macro | Excel Discussion (Misc queries) | |||
| Auto Filter Macro | Excel Discussion (Misc queries) | |||
| Auto filter macro | Excel Programming | |||
| Auto Filter in a macro | Excel Programming | |||
Linear Mode
