Microsoft KB Archive/148210

= Using the FormulaArray Property Returns an Unexpected Value =

Article ID: 148210

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Excel 5.0c
 * Microsoft Excel 5.0 for Macintosh
 * Microsoft Excel 5.0a for Macintosh

-



This article was previously published under Q148210



SYMPTOMS
When you use FormulaArray property in a Microsoft Visual Basic for Applications macro in Microsoft Excel 5.0, it may return a zero rather than the expected value.



CAUSE
This problem may occur if the following two conditions are true:


 * The workbook that the FormulaArray property is applied to is closed. -and-


 * The cell that the property is applied to is partially formatted with the Rich Text Format (RTF).

NOTE: To create an example of a cell that is partially formatted with RTF, use the following steps:


 * 1) Double-click a cell with some text in it to activate it for in-place editing. If double-clicking the cell does not activate in-place editing, click Options on the Tools menu, select the Edit tab, and make sure the "Edit Directly In Cell" check box is selected.
 * 2) Select part of the text, and click Cells on the Format menu.
 * 3) Format the data in the cell as desired, and click OK.



STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Microsoft Excel for Windows 95, version 7.0 and later.



MORE INFORMATION
The FormulaArray property returns or sets the formula of a range, entered as an array. It returns (or can be set to) a single formula or a Visual Basic array. If the specified range is an array, this property returns Null.

