Prev: Comparing data in cells
Next: finding data across multiple ws to populate a userform (Need H
From: Harry on 17 Jul 2008 16:05
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
From: Dave Peterson on 17 Jul 2008 18:52
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
 | 
Pages: 1
Prev: Comparing data in cells
Next: finding data across multiple ws to populate a userform (Need H