In the VBE go to Tools, Options, and make sure "Unhandled Errors" is selected
Ok so, it seems like now it searches. What does "break on unhandled errors" mean? does it mean that it's ignoring run time error 5 and just forcing itself to proceed to complete the code?