I want to write a VBA procedure to determine the size (in RAM) of an
object, e.g., a Scripting.Dictionary. Is there anyway to do this?

If there is no direct way, perhaps it is possible to run some simple
diagnostics like check how much memory VBA has allocated, dim a new
dictionary, check memory allocation again, add 1000 items, check
allocation again... just to get a sense of how much overhead is
involved with the object. Can this be done?

ANy help would be appreciated!

You can use the following properties to determine memory usage before and
after your call to the scripting dictionary

application.memoryfree
application.memorytotal
application.memoryused


--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"R Avery" wrote:

I want to write a VBA procedure to determine the size (in RAM) of an
object, e.g., a Scripting.Dictionary. Is there anyway to do this?

If there is no direct way, perhaps it is possible to run some simple
diagnostics like check how much memory VBA has allocated, dim a new
dictionary, check memory allocation again, add 1000 items, check
allocation again... just to get a sense of how much overhead is
involved with the object. Can this be done?

ANy help would be appreciated!