PDA

View Full Version : Solved: Memory used



philfer
12-29-2009, 02:18 PM
Hello,

Is there a way to determine how much memory is being used by a VBA procedure i.e. as it creates variables and objects and subsequently removes them from memory?

Thanks
Phil

GTO
12-29-2009, 03:19 PM
Greetings,

Probably a better way and I wouldn't wager on this, but I think you could use:

=INFO("memused")

...on a worksheet someplace. Then you could grab the val by code at the appropriate places and compare before/after... Not tested, but I would probably force a calculation before any time I grabbed the val of the cell.

Hope that helps,

Mark