I am using the following code to find PTS in column 2 and 3, the problem is it is only finding PTS if it appears in column 2 & 3 on the same row else you do not see them if PTS is just in column 2 or column 3.



ActiveSheet.Range("$A$6:$IP$340").AutoFilter Field:=2, Criteria1:= _
        "=PTS*", Operator:=xlOr
    ActiveSheet.Range("$A$6:$IP$340").AutoFilter Field:=3, Criteria1:= _
        "=PTS*", Operator:=xlOr

Is there a simple fix some one can provide that will display all rows containing PTS whether it is in column 2 or column 3 else i am having to run 2 seperate filters


Many thanks in advance

Mark