Continue next iteration of For loop

After a particular line executes, I want the next iteration of the for loop to take place. I have read that there is a continue statement. Some websites say "continue" or "continue for" but neither are working. For now I am trying to insert 'continue' after "Case 1."

Please Login or Register  to view this content.

Originally Posted by Richard Buttrey

Hi,

I'm not sure what you mean by a 'Continue' statement. I know of no such syntax in VBA. What exactly are you wanting to happen?

Once a Case statement is acted upon the program flow is then to the End Select line.

After the case statement executes, I want to jump over the IF statement below it, and go straight to the 'next' statement so that the next iteration of the loop can take place right away.

Originally Posted by Richard Buttrey

Do you mean the If statement should be avoided only if Case 1 processes.

If so why not use the ColNo variable in another IF Test just before the current If Test.

i.e.

Please Login or Register  to view this content.

If Case 1 is true, I want the program to jump over the IF statement below the Case and just go to the next iteration. I like the way it is set up now in terms of readability, I just need to find out how to start the next iteration.