View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Flemming Dahl[_2_] Flemming Dahl[_2_] is offline
external usenet poster
 
Posts: 18
Default Name of Current Macro running?

Hi Nigel

What I do is to make a private const in each module and in each procedure...
like this

Private Const mstrModuleName As String = "modPrintFeatures"

Public Sub PrintThe****()
Const strProcedureName As String = "PrintThe****"
End Sub

I then use these constants in my err handler.

Hope I helped you a bit
Flemming


"Nigel" wrote in message
...
I am developing a error handling routine and wish to note the name of the
module and sub that was running when the error occurs.

Is this available ?

--
Cheers
Nigel