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