Thanks for your answer. I was going to say that the other application doesnt matter, since it was happening with the simple For loop, but on turning my PC on today, and running the For loop, it doesnt hang and I can interrupt it at any time. So I guess its the other application that is causing...
I am writing code for an excel sheet, which constantly polls another application for information. I am having problems being able to interrupt this. My excel version, as far as I know, is Excel 2007
I did a quick search and came up with this code
Public Sub Start()
On Error Goto...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.