XL2000: "Name cannot resemble a reference." Error When Changing Reference Style Setting

• Microsoft Excel 2000

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:

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:

1. On the File menu, click Close. Save changes to your workbook if necessary.



2. On the File menu, click New.



3. On the Tools menu, click Options.



4. On the General tab, change the R1C1 reference style check box as appropriate. Click OK.



5. Reopen the original workbook.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

Additional query words: XL2000 R1C1 A1 row column

Keywords : kberrmsg xldraw
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug