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