The For Each
block is entered if there is at least one item in group. If the loop has been entered, then all the statements in the loop are executed for the first item in group. If there are more items in group, then the statements in the loop continue to execute for each item. If there are no more items in group, then the loop is exited and execution continues with the statement following the Next
The Exit For
can only be used within a For Each...Next
control structure to provide an alternate way to exit. Any number of Exit For
statements may be placed anywhere in the loop. The Exit For
is often used with the evaluation of some condition (e.g. If...Then...Else
), and transfers control to the statement immediately following Next
You can nest For Each...Next
loops by placing one For Each...Next
loop within another. However, each loop element must be unique.
Note: If you omit item in a Next
statement, execution continues as if you had included it. If a Next
statement is encountered before its corresponding For
statement, then an error occurs.