Line number in error handler

[cereldine]

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

[RB Smissaert]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>