on error exit sub
 

as the title says how can it be done i assume it has to go to an erro
handler but any help would be apprechiated thank

--
short_n_curl
-----------------------------------------------------------------------
short_n_curly's Profile: http://www.excelforum.com/member.php...fo&userid=2157
View this thread: http://www.excelforum.com/showthread.php?threadid=38875

on error exit sub
 

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