XL5: Macro Fails If Worksheet Name Contains a Hyphen

ID: Q125912

The information in this article applies to:

Microsoft Excel for Windows, version 5.0

SYMPTOMS

In Microsoft Excel, when you attempt to change a property of or perform a method on a locally defined name in a worksheet, you may receive the following error message:

Run-time Error '1004':

That Name is Not Valid.

CAUSE

This problem occurs if the local name is defined on a worksheet and the worksheet name contains a hyphen.

WORKAROUND

To avoid receiving this error message, rename the worksheet so that its name does not contain a hyphen. After you rename the worksheet, you should be able to change the properties of and perform methods on the defined name.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel version 5.0 for Windows. This problem was corrected in Microsoft Excel version 5.0c for Windows.

Additional query words:

Keywords :
Version : 5.00
Platform : WINDOWS
Issue type :