I have a worksheet where column U row 2 is a concatenate of calculated values across columns B row 2 : column R row 2 - which generates a random string of 68 letters.
In column V row 2 I have the formula =ISNUMBER(SEARCH("ANYWORD", " "&U2&" ")) which returns "TRUE" or "FALSE".
I have a recalc macro that recalcs all the underlying values and generates the random values.
How do I create a macro that runs a set number of times (loops x number of times) to do both the recalc and each time checks column V for any instances of "TRUE" which would then trigger a stop of further recalcs and would display to the user a message box saying "ANYWORD found!"
Bookmarks