Excel 97 and xlm language

Showing 1-1 of 1 messages
Excel 97 and xlm language Dennis Wilson 7/30/97 12:00 AM

This is just a heads up. If you have any Excel XLM macros and you are
expecting to bring them forward to Excel 97 without problems, you may be
saddened. I was trying to bring some stuff forward without rewriting,
and I found this slight flaw.
...
=FORMULA("=SUM(R[-10]C:R[-1]C)")
=RETURN()

What is broken is that now the error message no RETURN() or HALT() found
appears.
The easiest work around is to place =ERROR(FALSE) and =ERROR(TRUE)
around the =FORMULA function. This gets rid of the error message.