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
|