View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Error when running macro in Excel

JUST PERFECT!

Many many thanks!!!! Hope I am able to help you some day!

Regards,

Raphael

-----Original Message-----
Somewhere before you get the error, put this line in:

On Error Goto ErrHnd

Then at the end of your subroutine (before End Sub) put

this:

Exit Sub

ErrHnd:

Err.Clear

End Sub

This will essentially ignore your error and not show a

message. Note
that it ignores all errors, so if things stop working

right, you will
need to comment out the On Error Goto ErrHnd statement.

K


---
Message posted from http://www.ExcelForum.com/

.