get the name of the currently active procedure?
 

Is there a way to programatically get the name of the currently active
procedure?
(sub or function, and the module in which it resides)
thanks,
Harry

get the name of the currently active procedure?
 

Lots of people use a global variable and change that variable to the procedure
that they're in at the top of the module (when they enter the procedure).

I guess that MZTools has a routine that does this for you.
http://www.mztools.com/index.aspx

But there's nothing built into excel to do it for you.

Harry wrote:

Is there a way to programatically get the name of the currently active
procedure?
(sub or function, and the module in which it resides)
thanks,
Harry

--

Dave Peterson