Thanks. Just checked under XL2000 and effectively it does crash.

KL


"Harlan Grove" wrote in message
...
"KL" wrote...
Test it. Use of XLM functions in defined names will crash Excel 97
and 2000 (and probably also Excel 95).

I have. Been using XLM functions in defined names for a few years
under XL97 and 2K and have never run into problems. But, as you could
see, I have mentioned your comment in my post.

It happens when you copy cells containing references to such defined named
then try to paste into other worksheets. It always crashes Excel.