I can crash my version of Excel (2002) *at will* using ToolsFormula
AuditingEvaluate Formula. It happens when evaluating certain types of array
formulas. I've learned what formulas will cause this and avoid evaluating
them this way.

My version of Excel is up to date with all patches, so what causes it...???
Is it a bug...??? It is to me.

Biff

"cyx" wrote in message
...
Enter the following array formula to cell A2:
=IF(TRUE,IF(MAX(ROW($1:1)*ISNUMBER(A$1:A1))=0,1,2) ,3)
Use Ctrl-Shift-Enter to enter since it's an array formula.

It runs without any issues but when you try Tools-Formula
Auditing-Evaluate Formula, Excel 2003 crashed on the first step, which is
to
evaluate ROW($1:1).

If you enter the formula as a regular one, no crash when evaluating.

If I remove the outer IF, no crash when evaluating.

I haven't tried it on other versions of Excel. I am just wondering if
this
is a bug and the problem can be reproduced.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc