VBA Delete Entire Row if Contains Certain Text

[bigmacneb]

I've searched on here, but every code I put in gives me an error back. Data in column D, If any of the cells contains "Record Only" I need it to delete the entire row.
Thanks

 

[rileyma]

Thank you!

 

[JoeMo]

MNexcel,
You can only have one subroutine with the name test. Try naming your three subroutines test1, test2 and test3.

 

[moramramesh]

Can we search for multiple words and delete those rows?

 

[hiker95]

moramramesh,

We can not tell what worksheet(s), cells, rows, columns, your raw data is in.

And, we can not tell what the results should look like.

You could improve your chance of getting some help if you post some sample data and a sample of the results you would like to see. See this link for how to post your data. https://www.mrexcel.com/forum/about-...tachments.html

Alternately, you could upload a copy of your file to a free site such as www.box.com. or www.dropbox.com.

Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here.

Include a detailed explanation of what you would like to do referring to specific cells, rows, columns and worksheets.

If the workbook contains confidential information, you could replace it with generic data.