Wed 21 Dec 2011, 16:09Delegate Julie said...
Julie has attended:
Excel VBA Intro Intermediate course
Excel Advanced course
Directly jump to ErrorHandler: stop
Hey there, I really need your help please.
We did one project using vba, but after running, it directly jump to ErrorHandler:(stop became yellow colour)
On Error GoTo 0
Exit Sub
ErrorHandler:
Stop
Resume
If ExcelErrorHandler("Public Sub ArrayB") = True Then Resume Next
End Sub
So I am not sure where is wrong? Could you help me please?
Thank you!
Regards
Julie
Thu 22 Dec 2011, 09:41Trainer Anthony said...
RE: directly jump to ErrorHandler: stop
Hi Julie, thanks for your query. Try re-writing like so:
***
On Error GoTo Errorhandler:
<Your code here>
Exit Sub
ErrorHandler:
If ExcelErrorHandler("Public Sub ArrayB") = True Then Resume Next
End Sub
***
Hope this helps,
Anthony
