XL2000: "Name cannot resemble a reference." Error When Changing Reference Style Setting (231045)
The information in this article applies to:
This article was previously published under Q231045 SYMPTOMS
When you change the reference style setting in Microsoft Excel, you may receive the following error message:
Name cannot resemble a reference.
Old name: macro name
New name:
NOTE: To change the reference style, use the R1C1 reference style check box on the General tab of the Options dialog box.
CAUSE
This behavior may occur when the following conditions are true: - You change the reference style setting.
- The workbook contains a button that runs a macro.
- The button passes an argument to the macro.
WORKAROUND
To work around this behavior and change the reference style setting, follow these steps:
- On the File menu, click Close. Save changes to your workbook if necessary.
- On the File menu, click New.
- On the Tools menu, click Options.
- On the General tab, change the R1C1 reference style check box as appropriate. Click OK.
- Reopen the original workbook.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
| Modification Type: | Major | Last Reviewed: | 10/7/2003 |
|---|
| Keywords: | kbbug kberrmsg kbpending KB231045 |
|---|
|