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