View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Name of running sub???

You can code the name of the sub with in it. Excel isn't multitasking. So
you can design the sub to know about itself.

-
Regards,
Tom Ogilvy

"Ken Loomis" wrote in message
...
Is there a way to access the name of a current sub via VBA while a macro

is
running?

TIA,
Ken