Trouble is I don't know how to replicate the problem. I tried partial text ("TST-TST") which is in many cells in the test workbook you uploaded, but it just returned each instance in turn.
Try using Excel's built-in search and see if that finds them all. If not, then it may be some subtle difference in the data items. If it does, then it must be my code, but I have no way to find it on my side.
Perhaps if you could create a small sample workbook that contains even one of the search terms that are affected, repeated four or five times, but then substitute dummy data for all the sensitive items. It only needs to be a few records, and possibly one worksheet. Just enough for me to see where the code loses the thread.
Meanwhile, here's the revised code with the Not Found notice.
Bookmarks