Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding Procedure which generated error
Hi
I have a worksheet with several modules each with several procedures. I have dealt with all the errors I can anticipate (which means there must be some that I have not dealt with!) and have handled those with a common 'if all else fails' error procedure. This will leave the worksheet in a 'safe', mode ensuring sheets are hidden or protected. The procedure also generates a message showing Err.Number and Err.Description, however it would be useful to know which procedure actually generated the error so that when I get a call about it I know where to start looking. I tried using Err.Source but that just gives the name of the entire project - not the module or better still, the procedure name. Is this possible? Thanks LS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
simplify procedure to get rid of 0 error values in a spreadsheet | Excel Worksheet Functions | |||
VBA Compile error: Procedure too large? | Excel Discussion (Misc queries) | |||
How to remove red strikethrough generated as an error? | Excel Discussion (Misc queries) | |||
Error: The procedure number is out of range | Excel Programming | |||
EXCEL.EXE has generated an error...when closing a workbook | Excel Programming |