Sounds interesting, but where do you download that code from?

RBS


"JP" wrote in message
...
Here's what I use:

http://www.aspfree.com/c/a/Microsoft...VBA-Details/1/

FYI, Application.VBE.ActiveCodePane.CodeModule will give you the name
of the module containing the procedure where the error occured.

--JP

On Oct 13, 9:13 am, headly wrote:
Is there a command to get the name of the running procedure?
The reason: My main procedure calls 10 smaller procedures; If any of those
10 procedures throws an error, i want to continue processing and i don't
only
want to capture the error code and description, but get the name of the
procedure where the error occured.