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 statement.
The
Exit For can only be used within a
For Each...Next or
For...Next control structure to provide an alternate way to exit. Any number of
Exit For statements can 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.