I've always had problems with Excel 2002 crashing when I use the formula
auditing tool, evaluate formula, on really "complex" array formulas.

I'm sad to say Excel has hit a new low and even crashes on a simple formula
like this:

=IF(A10,(MATCH(TRUE,A2:A$100,0)-1)*A1,"")

It crashes evaluating the array:

A2:A$100

I pretty much have learned what formulas will cause a crash and don't use
the evaluate formula command on those formulas but this latest one is a joke
(but I'm not $%^*($%% laughing).

Yes, I know I can highlight expressions and press F9 but it's not the same
as evaluate formula. Evaluate formula is a great tool when it doesn't cause
a crash!

Rant over.

Biff