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

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

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.

Properties

Article ID: 823604 - Last Review: October 9, 2011 - Revision: 2.0
APPLIES TO
  • Microsoft Excel 2002 Standard Edition
Keywords: 
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