R
Ron Rosenfeld
<sigh>. It seems morefunc.xll, Laurent Longre's excellent add-in, is less and
less functional in Excel 2007. I know have several functions that, when
implemented, result in Excel crashing. The most recent was INDIRECT.EXT, which
allows the use of the INDIRECT function on closed workbooks. If I had open the
workbook containing the function; and then opened the target workbook; Excel
would crash. Changing the INDIRECT.EXT to an INDIRECT function was the fix for
that behavior. Of course, now the target workbook has to be open.
There are some other functions that don't seem to work well in Excel 2007, as
well.
--ron
less functional in Excel 2007. I know have several functions that, when
implemented, result in Excel crashing. The most recent was INDIRECT.EXT, which
allows the use of the INDIRECT function on closed workbooks. If I had open the
workbook containing the function; and then opened the target workbook; Excel
would crash. Changing the INDIRECT.EXT to an INDIRECT function was the fix for
that behavior. Of course, now the target workbook has to be open.
There are some other functions that don't seem to work well in Excel 2007, as
well.
--ron