It is possible that the setting MatchCase:= True could be the culprit. If
your What is not the same case as the target cells, then it will not return
them.

"anon" wrote:

Apologies, I have adjusted my code so it is now correct and I no
longer get the error;

If not foundcell Is Nothing Then
foundcell.Activate

However why is my find not finding?! I can see plain as day the values
are there however it is not finding them.