#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,574
Default =INFO("memused")

When I enter this formula the number 7514856 is returned. How do I interpret
this? How many MB of memory is this?

When I look at the task manager it tells me XL is using 12MB of RAM. I'm
using XL 2000 here.

Thanks,

Dave

--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 353
Default =INFO("memused")

Memused displays the amount of heap memory being used to track cells and
formulas, provide copy and paste functionality, etc. It does not include the
memory used by the Excel program and workbook. The value returned is in
bytes, so 7514856 would be equal to about 7.2 MB.

Just FYI - in '07 - "memavail", "memused", and "totmem" are no longer
supported.


"Dave F" wrote:

When I enter this formula the number 7514856 is returned. How do I interpret
this? How many MB of memory is this?

When I look at the task manager it tells me XL is using 12MB of RAM. I'm
using XL 2000 here.

Thanks,

Dave

--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Retrieving info from "child" to a "parent" document create button to unhide rows Excel Discussion (Misc queries) 0 January 21st 07 10:40 PM
HELP on "left","right","find","len","substitute" functions serene83 Excel Discussion (Misc queries) 5 June 27th 06 02:23 AM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next BCB New Users to Excel 7 May 13th 06 10:02 PM
Complex if test program possible? If "value" "value", paste "value" in another cell? jseabold Excel Discussion (Misc queries) 1 January 30th 06 10:01 PM
Insert "-" in text "1234567890" to have a output like this"123-456-7890" Alwyn Excel Discussion (Misc queries) 3 October 25th 05 11:36 PM


All times are GMT +1. The time now is 01:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"