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