Microsoft KB Archive/65101

{|
 * width="100%"|

Err Msg: &quot;That Name Is Not Valid&quot; or Macro Error at SET.NAME

 * }

-

The information in this article applies to:


 * Microsoft Excel for the Macintosh, version 1.x, 2.2, 3.0, 4.0

-

SUMMARY
In Microsoft Excel, a defined name cannot be created with the name &quot;C&quot; or &quot;R&quot;. If this is attempted, Excel will display a dialog box stating &quot;That Name Is Not Valid.&quot; A defined name such as &quot;R12XYZ&quot; will cause the error dialog box to be displayed.

The characters &quot;C&quot; and &quot;R&quot; are reserved for use in &quot;R1C1&quot; notation.

Any name that could be confused with a cell reference is invalid. Any name that begins with a number is also invalid. Examples of names that cannot be used are &quot;C&quot;, &quot;R&quot;, &quot;RC&quot;, &quot;A1&quot;, &quot;AB2&quot;, &quot;DF24&quot;, &quot;ZZ140&quot;, &quot;1A&quot;, and &quot;22Name&quot;.

The macro commands DEFINE.NAME and SET.NAME, which are used to define names, are also restricted by the above conditions. If a name is invalid, a macro error will result, indicating the cell on the macro sheet that contains the DEFINE.NAME or SET.NAME formula.

Additional query words:

Keywords :

Version :

Platform :

Issue type :

Technology :