Memory size of an object like array

[jakopak]

Dear excel Help,

For optimization of speed vs memory size I would like to have function which measures allocated memory of an object.
I don't know if I remember correctly. I think it is possible. Maybe through declare statement.

[Andy Pope]

See the help on the Len function.

"Returns a Long containing the number of characters in a string or the number of bytes required to store a variable."

There is also LBound and UBound to get the dimension of an array