Name of Procedure

[Adept]

Is there a +AFs-simple+AF0- way to get the name of the routine (Sub or Function)
currently executing? (By simple, I mean without SubClassing Excel as
My Excel +AH4- )

Example

Sub XYZ

Dim Name

Name +AD0- f(n)

' Name now +AD0- +ACI-XYZ+ACI-

End Sub

Thanks,





--



And we carried our bits in a bucket,
And our mainframe weighed 900 tons,
And we programmed in ones and in zeros
And sometimes we ran out of ones.

 

[Chip Pearson]

Unfortunately there is no way to do this.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com