Excel 2008 : How to select/find all rows containing specific wording

How to select/find all rows containing specific wording and then delete those. Is there a way to highlight words containing for instance, a lowercase 's' or word in a column. Then be able to delete all at once (I have over 60,000 products and need only certain ones deleted at once).

Madirish,

You can use the below code. Notes about the macro:

• Update the strCriteria to desired
• Separate each search criteria in the strCriteria with a comma (as shown in the example)
• The strCriteria is case sensitive (so, like in the example, you want to get rid of all rows in column A that contain a lowercase "s", it will retain all items with an uppercase "S")

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar