Searching array for strings in array VBA : <p>I have declared an array containing 59 items as a string. Does anyone know how I could write a bit of code that would search another range (A:F), and highlight any cell that contained one of the items in my array yellow.</p>

<p>I think this might be a loop inside of another loop, but I am not sure how to construct it. Apologies for the lack of code, I hope the explanation is clear.</p>

<p>Thanks!</p>
