Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() i wanna know error line and module name when outbreak of error in any module. Sub test() On Error GoTo erohandle: ~~~~~ ~~~~~ Exit Sub erohandle: MsgBox "the current module name is " & xxxx & vbCrLf & "the line number is " & yyyyy End Sub *** Sent via Developersdex http://www.developersdex.com *** |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Go to line in Module | Excel Programming | |||
How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) | |||
Get Module line # for error trapping | Excel Programming | |||
On Error, Capturing current module and actual line of code | Excel Programming | |||
Strange Module line | Excel Programming |