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)