XL5: Using the FormulaArray Property Returns an Unexpected Value

• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for the Macintosh, versions 5.0, 5.0a

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.

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:

   FormulaArray