Looking for information on how VBA allocates memory for arrays in Excel

[AnnaHansen]

I am working on a project that has to handle large volumes of data. I can find a lot of information about how to declare and size a dynamic array in VBA but not a lot about how VBA allocates memory under the covers when you make those calls. Can anyone point me towards information in this regard?

 

[RoryA]

What specifically do you want to know? Thee isn’t a lot of documentation on this that I’m aware of.

 

[AnnaHansen]

My primary question is how much space is allocated when the array is declared with a variant or string type.

 

[RoryA]

This is probably a good place to start (plus one or two good links in comments): https://stackoverflow.com/questions...opulating-variant-array-increase-memory-usage

 

[AnnaHansen]

that was super helpful, thank you!

 

[RoryA]

Glad to help.