Thanks Bob!
Your method is also an option for me.
It would have been a nice feature though...


On 15 feb, 12:14, "Bob Phillips" wrote:
No, afraid not, we would all love there to be one.

What I do is to create a global variable, and set it at the head of each
procedure, painful, but I know of no better way.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Jantje" wrote in message

oups.com...



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- Tekst uit oorspronkelijk bericht niet weergeven -

- Tekst uit oorspronkelijk bericht weergeven -