Anthony's VBA Forum
Where the knowledge is shared
Menu
Home Page
Forum Index
FAQ
Memberlist
Usergroups
Register
Profile
Messages
Login/Out
Quick Search
Advanced Search
Links
Consulting
Products
Who's Online
[
Administrator
]
[
Moderator
]
Nested Error Handling
Anthony's VBA Forum Index
->
General Excel VBA
View previous topic
::
View next topic
Author
Message
dh273
Joined: 11 Dec 2008
Posts: 1
Posted: Thu Dec 11, 2008 11:51 am
Post subject: Nested Error Handling
Hi. I'm trying to sort out some code for what to do if an error is caught in an error handling module. In other words,
[code]
function myFunction()
On Error GoTo errHandler
'some code here
exit function
errHandler:
'more code here. If an error occurs here, how can I send it to another area of the code to handle this error
end function
[/code]
Back to top
mohan.ankur
Moderator
Joined: 02 Aug 2006
Posts: 52
Posted: Fri Dec 19, 2008 3:14 pm
Post subject:
Did you try on error goto 0
This resets the original error handler.
_________________
http://www.exceldepot.com
http://www.xlmacros.com
http://www.learnexcel.org
Back to top
Display posts from previous:
All Posts
1 Day
7 Days
2 Weeks
1 Month
3 Months
6 Months
1 Year
Oldest First
Newest First
Anthony's VBA Forum Index
->
General Excel VBA
All times are GMT - 4 Hours
Page
1
of
1
Jump to:
Select a forum
Excel VBA
----------------
General Excel VBA
VBA on Finance and Investment
----------------
Option Pricing Models
Portfoilio Optimization
Other Finance Topics
VBA on Statistics
----------------
Probability Distributions
Monte Carlo Simulation
Regression Analysis
Announcement
----------------
Updated News
You
cannot
post new topics in this forum
You
cannot
reply to topics in this forum
You
cannot
edit your posts in this forum
You
cannot
delete your posts in this forum
You
cannot
vote in polls in this forum
Powered by
phpBB
© 2001, 2002 phpBB Group