Can't Define Name with Same Name as a Subroutine (111281)
The information in this article applies to:
- Microsoft Excel for Windows 5.0c
- Microsoft Excel for the Macintosh 5.0a
This article was previously published under Q111281 SYMPTOMS
In Microsoft Excel version 5.0, you cannot define a new name that is the
same as the name of a currently running Microsoft Visual Basic for
Applications subroutine. If you attempt to do so, you will receive the
following error message:
Run-time error '1004':
Add method of Names class failed
STATUS
This is a known problem in Microsoft Excel 5.0. This problem was corrected
in Microsoft Excel for Windows 95, version 7.0 and later.
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbbug kbcode kbfix kbProgramming KB111281 |
---|
|