excel vba exit do loop infinite code example
Example: excel vba exit do loop infinite
'VBA has the Exit Do statement to exit a Do Loop:
Do
c = c + 1
If c = 750 Then Exit Do
Loop While i < 1000
'-------------------------------------------------------------------
'Note: If multiple Do Loops are nested, Exit Do transfers
' control to the next higher level of nesting.
'-------------------------------------------------------------------
'VBA also has analogous Exit statement for
'For Next and For Each loops.
'VBA does NOT have an Exit statement for While Wend loops.