View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Return Procedure Name

The procedure name is not available as far as I know, so you would have to
manage it yourself. One way would be to have a global public variable, and
set that whenever a procedure is entered.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"tod" wrote in message
m...
I have my code append to a text file if there is an error. But the
results are vague. I'm just having it append the Err.Description to
the file. Err.Source doesn't tell me much. Is there a way I can also
append the procedure name where the error occured? Even better would
be the procedure name AND line number. But.. one can dream, I suppose.

Any suggestions or related help appreciated.

tod