Hi Mark,

Revised the code and included one extra line to handle your concern
see the attachment and test again. thanks.

CF if text found in sheet.xlsm

Regards,
DILIPandey

<click on below 'star' if this helps>