Apart from changing xlFormulas2, I recommend that you write the code in such a way that it does NOT reference the active sheet by default (because there is no qualifier for Range, Cells, etc.). It happens that the code will not work then.
Nor can it be optimistically assumed that the searched phrase will be found always. The day will come when she will not be found. Such a case should be programmed. I only gave a message and an exit from the procedure, but this is not always the correct approach to the problem, especially when the previous part of the macro has already made some changes to the workbook. I will not mention the lack of declarations of the variables used.
Corrected code below
Artik
Bookmarks