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

 

[SiuGuy007]

hiker95,

When I run this macro. the names ESIS change to #NA and the row is not removed. Am I doing something incorrect?

 

[hiker95]

hiker95,

When I run this macro. the names ESIS change to #NA and the row is not removed. Am I doing something incorrect?

SiuGuy007,

I will have to see the actual workbook/worksheet.

You can post your workbook/worksheets to the following free site (sensitive data changed), mark the workbook for sharing, and, provide us with a link to your workbook:

https://dropbox.com

 

[SiuGuy007]

The sheet is added. The #NA were where the name ESIS was.

https://www.dropbox.com/s/uhkq6trv88ftc9t/Monthly Report VBA ESIS.xlsx?dl=0

 

[hiker95]

SiuGuy007,

I will need to see the raw data in worksheet CasesRaw, not the results of the macro that display #N/A

 

[SiuGuy007]

Raw data uploaded. Note the ESIS items are in row H.

https://www.dropbox.com/s/uhkq6trv88ftc9t/Monthly Report VBA ESIS.xlsx?dl=0

Regards

 

[hiker95]

SiuGuy007,

Thanks for the new workbook/worksheet.

You are using Table Tools, and, the workbook/worksheet cells are Protected.

I have not been able to remove the protection, in order to delete the rows in column H, where cells have been changed to #N/A


Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[SiuGuy007]

Bump

 

[SiuGuy007]

I replied using Bump as requested. I am a little unclear on your message that the spreadsheet was protected. I have not protection on the cells or worksheet. It is the same as the others previously sent. Am I missing something here?

 

[hiker95]

I am a little unclear on your message that the spreadsheet was protected. I have not protection on the cells or worksheet. It is the same as the others previously sent. Am I missing something here?

SiuGuy007,

Your other workbook that I had worked on did not open as protected, or, with Table Tools active on the ribbon.

I can not understand/explain what is happening?


Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.

 

[SiuGuy007]

I fixed the spreadsheet.

https://www.dropbox.com/s/uhkq6trv88ftc9t/Monthly Report VBA ESIS.xlsx?dl=0

Thanks,

Michael