I couldn't understand why the find method wasn't working in a macro until I
realised that the range of cells I was searching didn't contain actual text,
but the result of formulae referring to text in another worksheet.

Is there a way of using find so that it will identify if the result of a
formula matches the text you're searching for?

Grateful for advice.