M8rix
03-22-2017, 06:36 AM
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
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