On error restart?

[liuec]

Hello, i'd very much appreciate it if someone can tell me how to write an error handling line that will rerun the current public sub or function from the start upon error...

thanks!!

 

[pbaldy]

Generally, include a line at the beginning like:

RestartPoint:

and in your error handler

GoTo RestartPoint

 

[liuec]

Thanks, that does the trick...
Here's another problem, is there a way that i can automatically click on the "End" bottom when the debugger message pops up??

Generally, include a line at the beginning like:

RestartPoint:

and in your error handler

GoTo RestartPoint

 

[pbaldy]

Well, you avoid it completely with proper error trapping:

http://www.baldyweb.com/ErrorTrap.htm