VBA - Delete entire row if criteria is not met

[Lalo2DaG]

Can someone please help me with VBA code. Here is my real world scenario. I have a report that contains several different statuses. I only need 4 of the many statuses. Ideally, the VBA code would delete rows that does not contain the 4 statuses. In addition, I would also like the code to not delete the first 7 rows at all. The first 7 rows contain miscellaneous information including the headers. Any help with this would be greatly appreciated.

FYI - I was on another thread and it was suggested that I may try my own thread to meet my needs. Here is the link to the thread I was on.

http://www.mrexcel.com/forum/excel-...applications-delete-row-if-cell-contains.html

 

[Trebor76]

It was all me. I was just being an idiot. It works well. Thanks!!!!!

No, that's fine. No problem.