Hi gmayor, did you get the chance to look into the above...I tried using asterisk with & sign but it doesn't seem to work. Can you please advise what is going wrong.
If InStr(1, olItem.Subject, "*" & xlSheet.Range("B" & iRow).value & "*") > 0