Is there a way to make VBA "watch" while a code is running, and if an error occurs, skip that part or do something besides Bug? Just i have a long somewhat complicated (for me neways) code, and other people use the Macro.. but if something bugs, which it does qutie often, it freezes the code partway through which messes a whole lot of stuff up.
It might be worth posting your code, you might be able to get help avoiding those errors in the first place rather than deal with them as they occur.
Anyhow, you can use the On Error statement to catch your errors and deal with them appropriately:
Go here for more info:
Please Login or Register to view this content.
http://www.cpearson.com/excel/errorhandling.htm
.
- AKK9 -
Here is the code...
I know that there are a lot of select this and select that that i could get rid of, but it doesnt seem to work as well...
Let me know what you can do.
Please keep in mind that 95% of the time the below code works absolutely perfectly....
Please Login or Register to view this content.
another code that seems to pop up with bugs every once in a while is...
Please Login or Register to view this content.
can you offer any help?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks