SET.NAME() Cannot Define a FormulaLast reviewed: November 3, 1994Article ID: Q69266 |
The information in this article applies to:
SUMMARYThe DEFINE.NAME() function in Microsoft Excel allows you to define a name as an expression that can be evaluated, such as =3*27 or =COS(x). If the SET.NAME function is used to define a name as such an expression, the name will be defined as the text of the expression, not the expression itself.
MORE INFORMATIONFor example, the statement
=DEFINE.NAME("func","=36+1")defines the name "func" to be the expression:
=36+1If a later cell in the macro contains the statement
=functhat cell will evaluate to the value 37. However, the statement
=SET.NAME("func","=36+1")defines the name "func" to be the text "=36+1", and if a later cell contains the statement "=func", that cell will evaluate to the text value "=36+1", which has a numeric value of zero.
REFERENCES"Function Reference," version 4.0, pages 100-101, 389-390 "Microsoft Excel Function Reference," version 3.00, pages 48-49, 217-218 "Microsoft Excel for Windows Functions and Macros," versions 2.1x, pages 266-267, 254-255
|
KBCategory: kbusage
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |