Function Name Can't be Same as Module Name (105571)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q105571 SYMPTOMS
In the versions of Microsoft Excel listed above, if you attempt to run a function that has the same name as a Visual Basic module, and the Visual Basic module is located in the same workbook as the function, you may
receive one of the following error messages:
Expected procedure, not module
Microsoft Excel cannot find '<function name>' on <workbook name>.
WORKAROUND
Instead of creating a function, create a Sub procedure. A Sub procedure can
have the same name as a module without causing an error.
Note that Sub procedures cannot be called from worksheet formulas.
Modification Type: | Minor | Last Reviewed: | 10/10/2006 |
---|
Keywords: | kbdtacode kbprb kbProgramming KB105571 |
---|
|