VBA delete row with cell contains specific values

This is driving me nuts as I have made a similar script few years ago. However, it's not to be found.

I want to add more values like 1009230, 1009231, etc. . I know it can be done with array but I am missing something.

Current script works with single value.

Best Thoms



Capture.PNG

Formula:

Please Login or Register  to view this content.

Try this code. The key is to convert the text in the array to a number.

Please Login or Register  to view this content.

This is perfect! Thanks for the tip and code.