Multiple If statements inside a for loop error

Hi - I am trying to run the following for statement for a long list of rows, checking to see if certain criteria are met, and if so, inserting a value into column "O". With the logic being that once a condition is met and a value is placed in column O, you exit the if statements and re-start the loop for the next line.

The problem is that I have one argument (checking column C and D) with an if statement within an if statement (bolded and underlined below). When running through, if the value in column C passes the test but not column D, then it falls out of the if statements, going to End If, instead of testing the next If statement, for column E. Can anybody think of a way to manipulate this so that if column "C" passes the check but not "D" it goes onto the next If argument (checking for col E) instead of falling out of the loop.

Please Login or Register  to view this content.