Record line number in macro where error occurs

[Spike]

When trapping errors, is it possible to record the line in the macro where
the error occurred so in the Error Trapping routine one can note this line to
assist in finding the error.

I copy error details to an Error Log so it would be handy to have the line
in the macro where the error trapping routine was triggered.

 

[Jacob Skaria]

This post will be helpful.
http://www.fmsinc.com/free/NewTips/VBA/ErrorHandling/LineNumber.html

If this post is helpful click Yes

 

[Spike]

Thanks for tha. So we have to number the rows of the macro, which is a shame
as makes it look scrappy but then if that is it so be it.

 

[Bernie Deitrick]

Spike,

For development work, in the VBE: Tools / Options "General" tab, check "Break on all errors"

HTH,
Bernie
MS Excel MVP

 

[Rick Rothstein]

Get MZTools... it's free and it's great! One of the many, many things it
does is allow you to add and remove line numbers at will.

http://www.mztools.com/v3/mztools3.aspx