VBA Delete rows if they do not contain...
Posted on 2009-04-24
Ok another dumb question, but I have to ask, I have a worksheet, in the sheet can be up to 65000 lines of text, I need to go through the text to refine it. In column L starting on Row 2 I need it to delete every row that does not contain the numbers:
13 20 21 22 23 24 27 28 91 92 93 94 95 and this list could grow later down the road so I would like to be able to simply add a number to it if needed.
Problem i am having is the column contains i.e.
Crtn Shortage-Freight Bill Signed Short 
Merchandise Billed Not Shipped 
So I would need the VBA code to look in this column, and see that there is  or  or any of the numbers I had listed, if those numbers are in the string, then delete the row, and move on to the next row.
Is there a simple way I can do this?