ExcelBanter - auto filter macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - auto filter macro (https://www.excelbanter.com/excel-programming/386996-auto-filter-macro.html)

Larry

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)

Norman Jones

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)

Larry

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)

All times are GMT +1. The time now is 08:05 AM.