Global Error Handling

[GTO]

Yes; any procedure that you want error handling in must have at least the

[vba]On Error GoTo MyErrHandler

'...code

MyErrHandler:
'...something here
End Sub 'End Function
[/vba]

...in it

You could read this KB entry by DRJ for a general error handler:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=189

Also, read thru the help topic for the On Error Statement.

Hope this helps,

Mark