get the name of the currently active procedure?

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
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run macro from active workbook whose name keeps changing 20
Even procedure in xla 1
Change Format of Active Cell 15
Function or formula to show currently active workbook name in cell 1
Procedure Name as a property? 5
Opening workbook in same directory 2
How to call module function or sub from the Add In? 3
application.activesheet, should I use it? 3

Top