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