I am finishing an autofilter and had a late add. In the code, I need to add a line that gives me only the cells that do have the text REJ in it. There are numerous other values in the same cell, I just do not want the ones that have REJ as part of it.
.AutoFilter Field:=7, Criteria1:="SPCLMDL"
.AutoFilter Field:=10, Criteria1:=Array( _
"CRTD", "PCNF LKD REL", "PCNF REL", "REL"), Operator:=xlFilterValues
.AutoFilter Field:=20, Criteria1:="<=" & Date, Operator:=xlAnd 'Late including today
.Sort Key1:=Range("T1"), Order1:=xlAscending, Header:=xlGuess, MatchCase:=False, Orientation:=xlTopToBottom, SortMethod:=xlPinYin
'Need to filter by not-equal to REJ in column 31, if the value REJ is anywhere in any cell in this column
'Sample data is CNF REJ PCNF REL could be in any cell.