Is there a way to filter using contain. I need to change the following code to pull up anything that has the array below in it. For instance: "QA Approval (Amended) Offer 3"" should pull up.
![]()
ActiveSheet.Range("$A:$V").AutoFilter Field:=2, Criteria1:=Array( _ "QA Approval (Closing Amended)", "QA Approval (Amended)", "QA Letters (Closing Amended)", "QA Letters (Amended)"), Operator:=xlFilterValues
Bookmarks