Yes, but I can add the module name to the error handler.

Now if I have:

- Module name
- Procedure name
- erl

would I then be able to get the linenumber of the module?

RBS

"Chip Pearson" wrote in message
...
As I said, you can't get the module name. Erl will return the line number
of the error, assuming that line has a label, otherwise it will return the
most recent line label.

Sub AAA()
10: On Error Resume Next
20: Debug.Print 1 / 0
30: Debug.Print Err.Source, Err.Number, Err.Description, Erl
End Sub

displays


VBAProject 11 Division by zero 20

in the Immediate window.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"RB Smissaert" wrote in message
...
OK, how about knowing the module name and the erl?

RBS

"Chip Pearson" wrote in message
...
I don't believe you can get the module name in which the error occurred.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"RB Smissaert" wrote in message
...
Is there a way to get the VBE module and module line, given the
procedure and erl where an error occured?
The idea is to move straight to the line in the VBE where the error
occured after handling the error.
I have numbered the lines per procedure with MZ Tools.

I can move to the line when I have the module and the module line:

With
ThisWorkbook.VBProject.VBComponents(strModule).Cod eModule.CodePane
.SetSelection lStartLine, 1, lStartLine, 1
.Show
End With

I could make my error handler retain the module as well as the
procedure, but even then I am not sure I could get
to the module line.


RBS