auto filter macro

[Guest]

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]

Hi Larry,

Try something like:

Selection.AutoFilter Field:=2, _
Criteria1:=Range("F3").Value

 

[Guest]

Thank you that worked just fine.

Hi Larry,

Try something like:

Selection.AutoFilter Field:=2, _
Criteria1:=Range("F3").Value