AutoFilter
I got some good responses regarding the autofilter problem from Dave
Peterson and Debra Dalgleish.
================
to check for multiple criteria in the same column, you could use a
formula like:
=OR(D2="A",D2="B",D2="C")
Just to save typing:
=OR(D2={"A","B","C"})
Or list the multiple criteria on the worksheet, then check if the value
in the current row is in the list, e.g.:
=COUNTIF($K$2:$K$4,D2)0
================
However, I don't know how to apply these. The formula I was using is:
Selection.Autofilter Field:=10, Criteria1:="A"
When I try to apply the "OR" example, I get an error.
I have a user form that has 5 checkboxes to select the filter for the
particular field.
How do I build the filter phrase in VBA?
GMet
|