Getting the size of a dynamic string array in memory
I have a dynamic array of strings.
Dim DynArray() As String
Redim DynArray(x,y)
How can I find the size of the array in memory?
I have searched for information on the String data type and how it is stored in memory, but couldn't find much.
If I had defined the size of the strings, this question would be easy. (x * y * SizeOfString) But my strings are of varying length.
Is there any way to do this easily? Or do I have to keep track of the size of every string in the array using the Len() function?
Any help greatly appreciated.
Cedric