On Error show msgbox with Ln XX, Col XX

[tony.reynolds]

Is there a way you can make errors show as the code name and ln, Col numbers instead of error debug/End

I have a workbook that anyone uses and id rather the user contact me with a error code so i can see where the error occured

 

[Joe4]

It depends on where the error is occurring in your code. If it is happening on some cell calculation, you can return it in Error trapping by adding a line like:

MsgBox ActiveCell.Address
(or whatever your cell reference is) to your Error handling code.

Here are a few links on Error Handling, if you are unfamiliar with it:
http://www.excelfunctions.net/VBA-Error.html
http://support.microsoft.com/kb/146864

 

[tony.reynolds]

Thanks for your help really appreciate it