Microsoft KB Archive/151276

-

{| The information in this article applies to:
 * width="100%"|
 * Microsoft Excel for Windows, versions 5.0

SYMPTOMS

When you use the FormulaArray property in Microsoft Excel for Windows, version 5.0, you may receive the following error message:

Error in formula CAUSE When you are using Visual Basic, Applications Edition to insert a worksheet formula into a cell, the error will occur even though the worksheet formula syntax is correct.

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, version 5.0c.

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 not array-entered, this property returns Null.

REFERENCES

For more information about the FormulaArray property in Microsoft Excel version 5.0, click the Search button in Help and type:

FormulaArray
 * }

-

Last reviewed: September 3, 1997

© 1998 Microsoft Corporation. All rights reserved. Terms of Use.