Microsoft KB Archive/211654

= XL2000: Error Message When You Copy a Formula Containing a Label =

Article ID: 211654

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q211654





SYMPTOMS
If you copy a formula from one cell to another, the resulting value may be a #NULL! error.



CAUSE
This behavior can occur if the following conditions are true:  You copy a formula that contains both a label and a defined name reference.

-and- The reference to the defined name is located between two label references, as in the following example:

=

-and- The Accept labels in formulas check box is selected (on the Tools menu, click Options, and then click the Calculations tab).



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
Natural language formulas allow you to refer to a cell range in a table by using row or column labels as the reference name.

