Delete row if not containing

Hi

Looking for a macro to delete rows that is not containing a specific numbers.

Ex:
Delete all rows where column "B" does not contain the numbers 10, 20, 30 and 40.

I've got this one, but this macro delete all rows containing a specific number (ex.10). I want the inverse macro:

Please Login or Register  to view this content.

I really appreciate some help with this one
Thanks

Hi,

Please use code tags when you post code to the forum. See Rule 3 of the Forum Rules.

Dom