If And Or Statement Help

Can someone help me with the following. Basically, I need the start of an if statement that looks at Column A and if the line begins with "N" and the ensuing line starts with "Startlist" or there is a blank line to go into the routine. This works perfectly up until I am at the end of my data set and the routine runs because it sees a blank line (even though the last line of the data set does not begin with "N"). Is there a way to make the requirement of having "N" in Column A absolute, so if that is false it goes into my other routines?

Please Login or Register  to view this content.

I believe there are two options and others may be able to chime in and assist further..
But one way would be to have your "N" condition its own and the others nested under that.. so that it has to be "N" before the others are even checked.

then another would be to find the last row in your dataset instead of using rowindex, which i believe will loop the entire sheet.

Not sure if this would be the correct format without a sample file, but just to give you an idea of what i meant by nested.

Please Login or Register  to view this content.

Thank you both for your help. Adding the parenthesis did the trick!