Microsoft KB Archive/174287

= XL97: Formula Returns Incorrect Value When Changed by a Macro =

Article ID: 174287

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



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.

Additional query words: XL97 chop cutoff clip wrong

Keywords: kbprb kbprogramming KB174287

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.