Delete rows with specific values

Any trics to make code below faster/easier/shorter?
I'm also out of OR statements and need to add more, I don't know how.
Thanks in advice for any help with this one.

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

Hi louvaek,

One way to get around the issue with all the or statements (and not having room for more) would be to add the items to a dictionary, and then just using that for a simple check. It may also speed things up slightly since the comparison gets simplified, but I doubt it will make a huge performance difference. I changed your loop because it said " For Lrow2 = Lastrow To Firstrow Step -1" but your variables have a 2 after them so this loop when tested was giving me Lrow2 values of 0

Please Login or Register  to view this content.