Solved: Memory used

[philfer]

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]

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