Answers for "excel vba exit while wend loop"

excel vba exit while wend loop

'VBA does NOT have an Exit statement for While Wend loops. While Wend
'loops must run through completion:
While i < 1000
    c = c + 1
Wend

'...or be interrupted by a GoTo statement:  
While i < 1000
    c = c + 1
    If c = 750 Then GoTo MyExit
Wend

MyExit:
'But using a GoTo statement is usually bad coding practice.