VBA on error next .....

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I add to my macro so that when it has an error it will by pass go
next step
or it will ignor and finish.
Thanks
Daniel
 
On error resume next
'troublesome code
On error goto 0 ' restore normal error handling

I would use this sparingly and only suppress errors where you absolutely
know it is appropriate (don't but it at the top of every module - if you do,
you will not understand why your code doesn't work).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top