Hi, I am currently using InStr to look for a String in another String
But what if I want to use multiple search criteria, with capitalization variants?findRefund = InStr(1, "Refund order - Item code 10000000", "Refund", vbTextCompare)
E.g.
Writing separate InStr lines for each criteria seems inefficient.Refund refund Exchange exchange Return return
How do you search for all of these criteria using minimal code?