Microsoft KB Archive/23834

{|
 * width="100%"|

Excel Err Msg: "Error in Formula" with a Function Macro

 * }

-

The information in this article applies to:


 * Microsoft Excel for Windows, versions 2.x, 3.0, 4.0
 * Microsoft Excel for the Macintosh, versions 1.x, 2.2, 3.0, 4.0

-

SUMMARY
In Microsoft Excel, when you are pasting the name of a function macro (using Paste Function on the Formula menu), the error message "Error in Formula" will be returned if the name of the function macro is a reserved name.

Names of built-in Microsoft Excel functions (such as MATCH) cannot be used for the name of a function macro.