Dave,
Thanks for your input, I still have the problem where I am looking for
more than one thing in a column and if it finds these I need to display
these only, I tried the below code as you suggested but it still does
not work.
I need to do a "multiple or" for more than just two criteria in a
specific column
Sub code()
With Range("a1:Z999")
.AutoFilter Field:=15, Criteria1:="9"
.AutoFilter Field:=15, Criteria1:="3"
.AutoFilter Field:=15, Criteria1:="5"
End With
End Sub
--
gerry405
------------------------------------------------------------------------
gerry405's Profile:
http://www.excelforum.com/member.php...o&userid=27939
View this thread:
http://www.excelforum.com/showthread...hreadid=474278