98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Directly jump to ErrorHandler: stop
Directly jump to ErrorHandler: stop
Resolved · Low Priority · Version 2010
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
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Convert Text to Columns in Excel 2010If you have a cell in your Excel spreadsheet that contains a lot of text and you want to divide it into separate columns, this can only be done if there is a logical character which separates the text, for example, a comma. |
