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:
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.
Additional query words: OfficeQFE 8443
Keywords: kberrmsg kbprb KB823604