View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bill Renaud Bill Renaud is offline
external usenet poster
 
Posts: 417
Default Macro name issue

Sounds like you are naming your code modules with the same name as the
subroutine. So in module 'GetAverageNum', you have a subroutine or function
also named 'GetAverageNum'?

Try naming your standard code module something like 'modMacros' or
'modMathFunctions', then put all of your macros in this single module.

--
Regards,
Bill Renaud