INFO( ) function

[cj]

when i using the function INFO() with "memavail" ,it
returned "1048576bytes" ,why so fewer ?
when with "totmem" ,returned "2951544bytes" ??


i don't understand what the ture mean of those value.

 

[Charles Williams]

Hi cj

INFO memavail and memused do not work correctly.
INFO memused returns the amount of memory used by Excel's memory manager.

see http://www.decisionmodels.com/memlimitsc.htm


Charles
______________________
Decision Models
The Excel Calculation Site
www.DecisionModels.com