Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

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

View products that this article applies to.

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

↑ Back to the top

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)")

↑ Back to the top

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)

↑ Back to the top

Status

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

↑ Back to the top

Keywords: KB823604, kbprb, kberrmsg

↑ Back to the top

Article Info
Article ID : 823604
Revision : 2
Created on : 10/9/2011
Published on : 10/9/2011
Exists online : False
Views : 204