I think that is the only approach and works very well, except it makes your
code look a bit messy.
Shame this can't be done without putting the numbers in.

RBS

"cereldine" wrote
in message ...

Hi, just wanted to clarify that there is no easy way to state the line
number that caused an error in a messagebox when producing a custom
error handler. Had a look at some other posts and they suggest erl, is
this the best approach, thanks


--
cereldine
------------------------------------------------------------------------
cereldine's Profile:
http://www.excelforum.com/member.php...o&userid=32069
View this thread: http://www.excelforum.com/showthread...hreadid=550305