MajP
You've got your good things, and you've got mine.
- Local time
- Today, 18:15
- Joined
- May 21, 2018
- Messages
- 9,686
When you are debugging it is often helpful to "turn off" the error handling.
So in front of lines like
On Error GoTo ErrorHandler
put a single quote before. Often called "commenting it out".
' On Error GoTo ErrorHandler:<br>
Now it will break on that error in the correct location (maybe depends on the function called where it breaks)
Just remember once you figure out the problem to "un comment" it so your handler works again.
If you are stuck on figuring out this application, I would spend time on how to debug your code. There are lots of tools and tricks.
I would google "How to debug VBA code" and you will probably get some good links and videos.
So in front of lines like
On Error GoTo ErrorHandler
put a single quote before. Often called "commenting it out".
' On Error GoTo ErrorHandler:<br>
Now it will break on that error in the correct location (maybe depends on the function called where it breaks)
Just remember once you figure out the problem to "un comment" it so your handler works again.
If you are stuck on figuring out this application, I would spend time on how to debug your code. There are lots of tools and tricks.
I would google "How to debug VBA code" and you will probably get some good links and videos.