LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 586
Default Return the Line Number where the Error Occured

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unexpected error has occured - AutoRecover has been disabled Hillary Excel Discussion (Misc queries) 1 November 27th 09 05:35 PM
An unavaliable error has occured Robert Excel Discussion (Misc queries) 2 August 26th 09 11:49 PM
Please help me to find out number of column occured pol Excel Discussion (Misc queries) 2 July 17th 09 05:41 PM
Unexpected error occured. - MS Excel Erlington Excel Discussion (Misc queries) 0 June 25th 06 04:30 PM
an error occured initializing the vba libraries 40040 sree Excel Discussion (Misc queries) 0 October 18th 05 07:43 PM


All times are GMT +1. The time now is 10:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"