Taco
0
Q:

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.    
4

New to Communities?

Join the community