Using the FormulaArray Property Returns an Unexpected Value (148210)
The information in this article applies to:
- Microsoft Excel for Windows 5.0
- Microsoft Excel for Windows 5.0c
- Microsoft Excel for the Macintosh 5.0
- Microsoft Excel for the Macintosh 5.0a
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: - 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.
- Select part of the text, and click Cells on the Format menu.
- 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.
REFERENCES
For more information about the FormulaArray property in Microsoft Excel
version 5.0, click Contents on the Help menu, click "Programming With
Visual Basic," click the Search button in Help and type:
| Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
|---|
| Keywords: | kbbug kbfix kbProgramming KB148210 |
|---|
|