Billy

I'm not sure they use more memory as they are one formula referencing the
array???

They are more difficult to work with after they are in place, but I believe
they are more efficient in memory

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"Billy Liddel" wrote in message
...
Array formulas take more memory than an ordinary formula, don't use them
unless you have to.

I'm sure XL2007 is the same.

Peter

"oldny" wrote:

After I put in a formula I always hit Enter, not (Ctrl + Shift + Enter),
does
it make a differnce in Excel 2007?