XL97: Formula Returns Incorrect Value When Changed by a Macro (174287)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
This article was previously published under Q174287

SYMPTOMS

When you use a Visual Basic for Applications macro to manipulate a formula, the formula is truncated and the value that is returned by the formula is incorrect.

CAUSE

This problem occurs when the following conditions are true:

  • You use a macro to copy or change a formula. -and-

  • The formula contains more than 1,016 characters.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
Modification Type:MinorLast Reviewed:10/11/2006
Keywords:kbprb kbProgramming KB174287
©2004 Microsoft Corporation. All rights reserved.