Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Kerri Gonzalez   on Aug 13 In MS Office Category.

  
Question Answered By: Ernesto Robinson   on Aug 13

Looking at the online help  for "On Error", "On error  GoTo 0"
disables any enabled error handler in the current procedure, so you
need to get rid of that if you want to keep your error handler.

Then, to make sure your code  does not fall into your error handler
by mistake, you generally put  an "Exit Sub" before it.

Next, you need a Resume (rather than Loop) at the end of the error
handler.

Share: 

 

This Question has 1 more answer(s). View Complete Question Thread

 


Tagged: