get the name of the currently active procedure?

  • Thread starter Thread starter Harry
  • Start date Start date
H

Harry

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
 
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.
 
Back
Top