Delete all rows containing a particular cell value.

**Doug24** · 10-25-2014, 02:22 PM

I would like to remove all rows that have the text "contest" in column D.

Thanks for any help,
Doug

**Richard Buttrey** · 10-25-2014, 02:25 PM

Hi,

Simplest way is to filter the column for the word 'contest' in column D, select all the rows, hit the delete button and remove the filter.

**sktneer** · 10-25-2014, 03:07 PM

You may try the following code to follow what Richard has suggested to you.....

Please Login or Register  to view this content.

Hope this helps.

**jayesh25** · 10-25-2014, 04:52 PM

Hello Doug24,

Rename the sheet name as appropriate and paste the below code on a fresh module.

Please Login or Register  to view this content.

**Doug24** · 10-25-2014, 05:23 PM

Thanks for all the help. The first two suggestions worked great and I'm going to try the "code" right now.

Doug

Re: Delete all rows containing a particular cell value.