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

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)

"Al" wrote in message
om...
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

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


"Al" wrote in message
om...
| 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

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.

--

"jaf" wrote in message ...
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


"Al" wrote in message
om...
| 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