I've built a macro that updates data in certain cells every 60 seconds by web query, then writes that data to a graph.
Sometimes the web query gives a time-out error (causing a message box to pop up), which causes the spreadsheet to freeze until you click the "ok" button.
I want to put some code at the start of my macro, to the extent of
But I have no idea how to refer to that error box.![]()
Please Login or Register to view this content.
How do I do that? Or if there's a better way to deal with this, shoot!
Bookmarks