Charles Williams wrote:
the only number that works is INFO("Memused")
There is a bug in INFO ("Memavail") it always returns the same number, and
INFO("Totmem") always equals INfo("Memused")+info("totmem") so is also
useless.
for more details on Excel memoru usage etc see
http://www.DecisonModels.com/memlimitsc.htm and associated pages
Charles
------------------------
Thanks Charles -- that explains some things.
It seems a bit slack on Microsoft's part to have such a basic known bug
exist all the way from the '97 version up to 2005. But then I guess
they don't much care what I think.
Bill