Macro help to search in all columns and delete rows accordingly

[JonnyNYC90]

Hello everyone!

I have a spreadsheet with many, many columns.
I would like to create a macro that can search for a specific word throughout the entire spreadsheet (for example, the word "Yes" in any column), and delete every row/entry that has the specific word in it, no matter what column.

Right now, I only have a macro that seems to search one column at a time. The code is:

Please Login or Register  to view this content.

Can I have a macro automatically search every column without me having to define the limits?

Thanks,
Jonny

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[JonnyNYC90]

Hi John,

Thank you so much for your help. While it does delete rows with the proper condition ("Yes" in any column), it does not delete every row. It seems to delete every other row, and I'm stumped as to why.

Thanks,
Jonny

[JOHN H. DAVIS]

In your data do you have cells which may have spaces dividing words (i.e "110 22", "good day", ect.)?

[Pepe Le Mokko]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[Pepe Le Mokko]

Are you using 2003 as indicated?

[JonnyNYC90]

Thank you very much Pepe Le Mokko...my apologies for being ignorant about the code tags and not updating my version of Excel.
I am using Microsoft Excel 2010.

[Pepe Le Mokko]

You will find what looks like an easy solution at this place. Perhaps recording a macro using this technique can get you on track?

[JonnyNYC90]

Thank you very much Pepe.

I have tried that solution, but need something that can search multiple words in multiple columns at once.
Also, recording a macro using that technique seems to not work whatsoever. It's a bit frustrating. It only seems to record the deletion of rows, with no rhyme or reason.

I will keep searching...any further help would be MUCH appreciated.

Thanks,
Jonny

[JonnyNYC90]

Here is what I have now!
The macro works, but can only seem to search one word at a time. Does anyone know how to change this?

Please Login or Register  to view this content.