Hello,
I have a worksheet of several thousand rows with about 50 columns and a sheet containing a list of text that are not allowed to exist in this worksheet (named it "Censored texts"). The censored texts might exist in a text string, not stand alone. I tried using formula to check if a column containing any text in the list. The formula worked but it made the computer freeze all the time and each column has to be checked once with the formula.
For example:
Column A in "Censored text" sheet contains the list of censored words: "Nudity, Naked, Erotic, ****, etc."
A cell in the active sheet contains: "Many people think that nudity in the public is a sin". Another cell says: "Being naked is good".
Do you have any VBA that can help me to check if any cell in the worksheet containing the texts and it'll have a message box that says the the cells location and the texts found.
Thank you in advanced,
I have a worksheet of several thousand rows with about 50 columns and a sheet containing a list of text that are not allowed to exist in this worksheet (named it "Censored texts"). The censored texts might exist in a text string, not stand alone. I tried using formula to check if a column containing any text in the list. The formula worked but it made the computer freeze all the time and each column has to be checked once with the formula.
For example:
Column A in "Censored text" sheet contains the list of censored words: "Nudity, Naked, Erotic, ****, etc."
A cell in the active sheet contains: "Many people think that nudity in the public is a sin". Another cell says: "Being naked is good".
Do you have any VBA that can help me to check if any cell in the worksheet containing the texts and it'll have a message box that says the the cells location and the texts found.
Thank you in advanced,