Hi,
Instead of having all the code in my sub, I decided to add function to divise the sub out.
However, in my sub, I have a Label statement Goto EXIT_DOOR which I declare just above the End Sub with some setting such as:
EXIT_DOOR:
Set ws = nothing
Set dmProject = nothing
End Sub
Now, how can in my function to do as if Error, go back to the sub but go to EXIT_DOOR of the sub?
Thanks
Unfortunately you can't jump to a label in another sub/function.
If posting code please use code tags, see here.
Any recommendation on how to do it via other way?
@Norie
I think you mean "fortunately"!
Use an error handler in the calling Sub.
Everyone who confuses correlation and causation ends up dead.
Can you give a example?
Please Login or Register to view this content.
Last edited by shg; 07-01-2015 at 01:16 PM.
Entia non sunt multiplicanda sine necessitate
I forgot. This function does call the error, but what if it's not related to error but more like: If a string is found?
See Help for the Err.Raise method.
Please Login or Register to view this content.
Last edited by protonLeah; 07-01-2015 at 07:44 PM.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks