3 Criteria on one column in AutoFilter?

[CLR]

Hi All...........

I'm trying to get Three criteria in a single column in an AutoFilter like
this

Selection.AutoFilter Field:=3, Criteria1:="<>EXP", Operator:=xlAnd, _
Criteria2:="<>CAP", Operator:=xlAnd, Criteria3:="<>(Blanks)"

The whole macro seems to work fine, except this section only seems to work
with two Criteria...........is that the limit?........is there another way I
can get all the returns in a column except the EXP, CAP, and Blanks?

TIA
Vaya con Dios,
Chuck, CABGx3

 

[Tom Ogilvy]

Autofilter only supports two criteria. You will need to use a dummy column
that has a formula to indicte which rows to hide or show. Then filter on
that column.

 

[CLR]

Okey dokey...........thank you very much Tom, I appreciate the quick
response........

Vaya con Dios,
Chuck, CABGx3