Microsoft KB Archive/174287

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Knowledge Base


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