VBA on error next .....
 

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

VBA on error next .....
 

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).

--
Regards,
Tom Ogilvy

"Daniel" wrote:

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