how to exit a while loop in vba code example
Example: 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.