Find rows containing specific data and delete

I have a large report that I pull each month listing which products we sold last month. There are certain products I don't want included in the report. Until I can have the report re-written, I'm looking for a macro or a function that will find all the rows that contain these product numbers in column M and delete the entire row. The product numbers I need to delete are always the same, but some months one or more of them might not be in the report if they weren't sold.

In Summary:

Find in column M the product numbers:
c1000
316140a
316140
316295a
316295
316311a
316311
316451a
316451
316450a
316450
316452a
316452

Delete those rows containing the product numbers above

Thanks in advance for any help!


ETA: I found a code (below) but when I highlight my row and run the macro, it deletes the first instance, but then I get an error saying "Object Required"

Please Login or Register  to view this content.

This should do it, it uses a loop, but only for the evaluation, for deleting it deletes all the found rows all at once which should be significantly more efficient.

Please Login or Register  to view this content.

Must not have any data to delete. I suppose I always assumed that when you ran the macro, there would always be at least one match.

Change that line to this so the macro won't bugger when you run it and there are no matches at all:

Please Login or Register  to view this content.

This should do it. If it still fails for some reason, I need to see the actual sheet/data you're trying this on.

You can add this to the top and it would make the whole macro non-case-sensitive.

Please Login or Register  to view this content.