Microsoft KB Archive/823604

= XL2002: &quot;Error 2029&quot; Error Message When You Use Application.Evaluate =

Article ID: 823604

Article Last Modified on 7/16/2003

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-



SYMPTOMS
When you evaluate a custom function that has a named range in an Excel 2002 workbook, you may receive the following error message:

Error 2029



CAUSE
This problem may occur if you type the following command in the Immediate window in the Visual Basic Editor and then press ENTER: ? application.Evaluate(&quot;=SUM(xyz,apple)&quot;)



WORKAROUND
To work around this problem, use a Microsoft Visual Basic for Applications (VBA) macro to insert a formula field in a cell, and then read the value back to your macro.

For example, use a macro to insert a formula that is similar to the following in a cell in your workbook: =SUM(xyz,apple)



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

Additional query words: OfficeQFE 8443

Keywords: kberrmsg kbprb KB823604

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.