"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.