Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a way to return the Line Number where an error occured in a module?
I currently have this and I think it would be useful to know the error location. Sub TEST() On Error GoTo ErrorHandler Const ModuleName As String = "Module1" Const SubName As String = "TEST" ' my code here Exit Sub '***************** ErrorHandler: Call ErrorHandler(ModuleName, SubName, "Error Line Location Here") End Sub -- Cheers, Ryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unexpected error has occured - AutoRecover has been disabled | Excel Discussion (Misc queries) | |||
An unavaliable error has occured | Excel Discussion (Misc queries) | |||
Please help me to find out number of column occured | Excel Discussion (Misc queries) | |||
Unexpected error occured. - MS Excel | Excel Discussion (Misc queries) | |||
an error occured initializing the vba libraries 40040 | Excel Discussion (Misc queries) |