How to easily crash Excel 2002.

[Jim Luedke]

Excel 10.2614.2625, at least.

In a VBA module, enter:

Function x(a) As String
Fubar
End Function

Function y(b) As String
End Function

In a cell, enter:

=y(x(0))

Get taken to 'Fubar' to debug. Press <Del> to delete the offending
word. Press <F5> to continue.

Redmond app go bye-bye.

***

 

[Jim Luedke]

Thanks, smartin.

Turns out, this is a serious bug.

My example was the reductio-ad-absurd-est I could get it, which may've
been a bad idea. Because here's the point:

==> Excel crashes on **every bug it encounters**, if it first executes
that y(x()) business. <==

Now, that could be an exaggeration; the bug might have limitations in
scope. But it's serious enough.

I now gotta save (or have Excel auto-save) frequently, 'cause a bug-
free-at-first-stab programmer I ain't, I have thousands of =y(x())
constructions in my sheets, and:

==> Excel 200X is crashing on me every few minutes. <==

***

Will someone try Excel 2007?

***