View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jim[_7_] Jim[_7_] is offline
external usenet poster
 
Posts: 19
Default GoTo won't work - why?

I fixed it. I changed Application.Goto TryAgain to just Goto TryAgain but
this didn't work either. I closed Excel and restarted it. Now it works.

"Jim" wrote in message
...
In a sub

TryAgain:

(some code)

Application.GoTo TryAgain

(more code)

End Sub

I never use GoTo statements except for error handling so I wonder if they
will backup as well as skipping lines? I really need this thing to back
up. When running, the Application.Goto TryAgain line is skipped as if it
isn't there. Not even an error. What's up?

Thanks for any help.