XL2002: "Error 2029" Error Message When You Use Application.Evaluate

Article translations Article translations
Article ID: 823604 - View products that this article applies to.
Expand all | Collapse all


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


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("=SUM(xyz(),apple)")


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:


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


Article ID: 823604 - Last Review: October 9, 2011 - Revision: 2.0
  • Microsoft Excel 2002 Standard Edition
kberrmsg kbprb KB823604

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com