View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jantje Jantje is offline
external usenet poster
 
Posts: 3
Default variable or propertie 'name' for self written sub or function

Hi, i just made a small sub 'logError' that writes the date, time,
err.Number and err.Description to a specified worksheet. I also want
to write the name of the Sub or Function that caused the error to be
raised...
Now i have to change the parameter each time i'm using the statement
'logError Date, Time, Err.Number, Err.Description, "name for sub or
function" '.
Can someone tell me if there's a variable to use that has the name of
a self made sub or function?
I hope the question is clear enough...
Thanks
jan