AFAIAA there is no documentation on this problem, but this previous post
from Harlan Grove sums it up nicely...
One thing the nice KB article DOESN'T mention is that if you copy any range
containing a cell formula dereferencing a defined name referring to an XLM
macro function and try to paste into another worksheet, you'll CRASH Excel
97 and 2K (others have confirmed that this has been fixed in XP). CRASH as
in Excel throws an exception and DIES, giving you NO CHANCE to save your
work. If you like unnecessary thrills, go for it. Otherwise wrap your XLM
calls inside VBA udfs (or dispense with XLM entirely and just use VBA udfs).
--
HTH
RP
(remove nothere from the email address if mailing direct)
"ivano" wrote in message
...
"Frank Kabel" ha scritto nel messaggio
...
Hi
just to add: This kind of 'formulas' / defined names could crash Excel
prior to version 2003 if you copy these formulas to other sheets
Can you tell me about this problem? there's link to explain defined names
crash Excel ?
Thank very much
ivano
|