G'day guys,
I have a long sub and it runs on a 9 second loop for 9 hours per day.
It may crash once or twice a day.
The instant solution is to hit a "stop button" which is on the program within excel and hit a "restart button" commencing the sub routines again.
Ultimately the dream... for it...