Hi,

Is there another VBA way I can use to show more than 2 values to search for
in a column. I would like to seacrh for 3 value in a column and show the
results in the entire row.

Selection.AutoFilter Field:=15, Criteria1:="=*fid*", Operator:=xlOr, _
Criteria2:="=*COLCHESTER*" I wanted to also search for a third
value of Criteria3:="=*TAX-EXEMPT*"

Hope that make sense.

Peter