Place the error handler flag next to "End Sub" viz:

Sub test()

On error GoTo errhandler

<code here


errhandler:
End Sub


--
davidm
------------------------------------------------------------------------
davidm's Profile: http://www.excelforum.com/member.php...o&userid=20645
View this thread: http://www.excelforum.com/showthread...hreadid=388754