line numbers in VB

[Jamie Altman]

i am trying to debug an Excel macro, but my error-trapping is not working. I am trying to use the Erl function/property to give me the code line number that is causing my error, but Erl always returns 0. currently i dont see the line numbers in my VB window, I need to turn on the code liner numbers. Is there a way to add vb line numbers?

 

[vletm]

Jamie Altman
Did You try to 'google'...?
and then You could find eg next:
https://usefulgyaan.wordpress.com/2013/07/10/tracking-the-line-number-where-error-occurs/
Or
https://excelmacromastery.com/vba-error-handling/

 

[Kenneth Hobson]

One can add line numbers using an addin or macro using
VBProject.VBComponents. A search will find both.

MZ-Tools is the usual addin I suspect.