View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ThisShouldBeEasy ThisShouldBeEasy is offline
external usenet poster
 
Posts: 6
Default On Error and Loops

If I exit a loop do to an error (On Error) can I then direct control back
into the loop via a GoTo?

e.g.

On Error GoTo EndofProc

For i = 0 to n
Resume:
' do stuff
Next i

Exit Sub

EndofProc:
i = i + 1
GoTo Resume