View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MarvInBoise MarvInBoise is offline
external usenet poster
 
Posts: 39
Default Insert macro name in code on call statement.

Perfect! Thank you!!
--
Marv Lusk
Boise Corporation


"Bob Phillips" wrote:

If you use a unique naming convention, like procMacroName, then by typing
proc and then hit Ctrl-spacebar you get a list of all procedures starting
with proc. I tend to name mine pXXFunction, where XX is a two letter acronym
for the module they are in, that way I can easily get them.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"MarvInBoise" wrote in message
...
Is there a way to list the macros (subs) that exist, sort of like F3 to

list
named ranges, so when I do a call to another macro, it will pop up the

name
so I dont' have to type it, thereby eliminating possible errors?
--
Marv Lusk
Boise Corporation