BREAK

Macro Sheets Only

Interrupts a FOR-NEXT, a FOR.CELL-NEXT, or a WHILE-NEXT loop. If BREAK is encountered within a loop, that loop is terminated and the macro proceeds to the statement following the NEXT statement at the end of the current loop.

Syntax

BREAK( )

Example

Use BREAK to test for conditions not anticipated by the FOR or WHILE statement. For example, use the BREAK nested in an IF statement to exit a WHILE-NEXT loop when a certain value is encountered:

=IF(Counter=8, BREAK())

Related Functions

FOR Starts a FOR-NEXT loop

FOR.CELL Starts a FOR.CELL-NEXT loop

NEXT Ends a FOR-NEXT, FOR.CELL-NEXT, or WHILE-NEXT loop

WHILE Starts a WHILE-NEXT loop

List of Control Functions