Hi all,
I'm writing a function to help toggle a timer on and off to see how long particular parts of code run on different users' PCs.
To do this, I'm trying to obtain the subs name once it kicks off to establish a start time, then at the end of it write the end time. This will all go to a text file via a script, or to a worksheet (depends on what works best once I start testing - nested routines will most likely direct me towards a worksheet to keep it simple).
Can anyone suggest how I obtain the name of the sub without hardcoding it? Want to keep as generic as possible. I've considered Application.Caller so far...
Thanks,
K
I'm writing a function to help toggle a timer on and off to see how long particular parts of code run on different users' PCs.
To do this, I'm trying to obtain the subs name once it kicks off to establish a start time, then at the end of it write the end time. This will all go to a text file via a script, or to a worksheet (depends on what works best once I start testing - nested routines will most likely direct me towards a worksheet to keep it simple).
Can anyone suggest how I obtain the name of the sub without hardcoding it? Want to keep as generic as possible. I've considered Application.Caller so far...
Thanks,
K
