VBA to delete rows from table that do not contain specific text

[gberg]

I am looking for a VBA code to delete rows from a table that do not contain an "M". The information is in the fourth column (Column D) and has a header of "Category". There are five options for what will be in Column D; "M", "S", "E", "L", "O". I want to delete any row that does not contain "M". I have a solution that runs a loop but there could be thousands of lines and this loop gets bogged down.

Any Suggestions?

 

[gberg]

Fluff, worked like a charm, simple and quick macro! Thanks once again for your help.

 

[Fluff]

Glad to help & thanks for the feedback.