XL97: Formula Returns Incorrect Value When Changed by a Macro

ID: Q174287


The information in this article applies to:
  • Microsoft Excel 97 for Windows


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 : kbprg kbdta xlformula KbVBA
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbprb


Last Reviewed: October 29, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.