VBA - Error Handling

[vba_monkey]

Hello,

I am using error handling in my macro using On Error GoTo and part of that is Debug.Print Err.Description which gives me the error in the Immediate Window but does not tell me which line the error is on as it would in Debug mode. How can I make it do this?

Thanks

 

[Derek Brown]

You could try:

Debug.Print "Line: " & Erl &  "  Desc: " & Err.Description

but you will need to have line numbers in your code.

 

[vba_monkey]

Thanks, that does the trick. I added line numbers using MZ Tools.