Address Subroutine Name from within Sub

[Al]

Hi folks,

Is there any way to refer to a subroutines name from within the
subroutine itself in the same way that you can have:

ActiveWorkbook.Name

Thanks,
Al

 

[Bob Phillips]

Al,

I don't think that there is any way that you can get this information from
the system, VBA, or Excel.

To get what you want, I think you would have to manage it all yourself.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[jaf]

Why would you ever need to?

sub test()
test 'recursive call
if a<"" then test 'ditto
end sub


--
John
johnf 202 at hotmail dot com


| Hi folks,
|
| Is there any way to refer to a subroutines name from within the
| subroutine itself in the same way that you can have:
|
| ActiveWorkbook.Name
|
| Thanks,
| Al

 

[onedaywhen]

If you called the sub using the CallByName function, you could pass
the name of the sub as an arguement. I too have no idea why you'd want
to do this, but then I've never found a legitimate use of CallByName.