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