The information in this article applies to:
SYMPTOMSIn Microsoft Excel, when you use the Formula property or the ConvertFormula method in a Visual Basic for Applications procedure, you may receive the one of the following error messages when you run the procedure, even if the formula that you assign or convert is valid: Microsoft Excel, version 7.0
Microsoft Excel, version 5.0
CAUSE
This problem occurs when you assign a formula using the Formula property,
because Microsoft Excel converts the A1-style notation formula to R1C1-
style notation. The error message appears if the resulting formula in the
R1C1-style notation exceeds 255 characters, the character limit for a cell
in Microsoft Excel. Note that a formula in R1C1 notation generally contains
more characters than the same formula in A1 notation.
WORKAROUNDTo avoid this error when you use the Formula property or the ConvertFormula method with a long A1 style formulas, especially using absolute references, use any of the following methods. Method 1Use R1C1-style references in your formula instead of A1-style references so that you can count on the expected limit of 255 characters.NOTE: If possible, you should also use absolute references rather than relative references. Method 2Use shorter formulas when possible.STATUSMicrosoft has confirmed this to be a problem in the versions of Microsoft Excel listed at the beginning of this article. This problem was corrected in Microsoft Excel 97 for Windows and Microsoft Excel 98 Macintosh Edition. REFERENCESFor more information about the Formula Property, choose the Search button in the Visual Basic Reference and type: Formula PropertyFor more information about the ConvertFormula Method, choose the Search button in the Visual Basic Reference and type: ConvertFormula Method Additional query words: 5.00a 5.00c 7.00a XL5 XL7
Keywords : kbprg PgmOthr |
Last Reviewed: October 20, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |