Thread: AutoFilter
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GMet GMet is offline
external usenet poster
 
Posts: 23
Default 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