Return the Line Number where the Error Occured

[RyanH]

Is there a way to return the Line Number where an error occured in a module?

I currently have this and I think it would be useful to know the error
location.

Sub TEST()

On Error GoTo ErrorHandler

Const ModuleName As String = "Module1"
Const SubName As String = "TEST"

' my code here
Exit Sub

'*****************
ErrorHandler:
Call ErrorHandler(ModuleName, SubName, "Error Line Location Here")

End Sub

 

[Daniel.C]

You can use "erl" if your code lines are numbered :
14 On Error Resume Next
15 Workbooks.Open "NotAvalidOne.xls"
16 MsgBox Erl

 

[Bob Phillips]

Just to add to Daniel's response, you don't need to add line numbers to
every line. If you just scatter them every so often, it will report the last
line number it encountered as the offending line. You could then home in on
the actual line.

There is also a free VBE addin, MZ-Tools, that, amongst other things, adds
and removes line numbers to and from your code. You can get it at
http://www.mztools.com/v3/download.aspx

--
__________________________________
HTH

Bob

You can use "erl" if your code lines are numbered :
14 On Error Resume Next
15 Workbooks.Open "NotAvalidOne.xls"
16 MsgBox Erl

 

[RyanH]

how do you number your lines?
--
Cheers,
Ryan

You can use "erl" if your code lines are numbered :
14 On Error Resume Next
15 Workbooks.Open "NotAvalidOne.xls"
16 MsgBox Erl

 

[RyanH]

Wht is the advantage to having line numbers? Is this the only case you would
need line numbers?
--
Cheers,
Ryan

Just to add to Daniel's response, you don't need to add line numbers to
every line. If you just scatter them every so often, it will report the last
line number it encountered as the offending line. You could then home in on
the actual line.

There is also a free VBE addin, MZ-Tools, that, amongst other things, adds
and removes line numbers to and from your code. You can get it at
http://www.mztools.com/v3/download.aspx

 

[Daniel.C]

Manually, unless you use the addin indicated by Bob. As far as I know,
numbering lines has no great use, but certainly, the addin should have other
interesting functionalities.
Daniel

how do you number your lines?