Run multiple if statements

What I am trying to do is run the code below for the same worksheet.

The problem is Excel will only allow me to run one or the other.

I want them to work at the same time.

Please Login or Register  to view this content.

Any help is greatly appreciated

Hi,

Firstly, could you please indent your code in the future, it makes it a lot easier to read. Secondly, just remove the Exit Sub statements, and reverse the polarity of the If...Then statements, like this:

Please Login or Register  to view this content.

Please note, I haven't tested this, I have done it off the top of my head. So please let me know if it still doesn't do what you're looking for and I'll take another look at it.

I hope this helps

Thank you protonleah. That worked perfectly.

Thank you very much. This worked perfectly.

Please don't forget to mark this thread as solved