How much memory do Arrays hog up???

I have an array:
Dim MapTable(1 To 50, 1 To 12)

I was reading that each array element can hold 64K characters, AND the memory is reserved in advanced

I'm pretty sure this is wrong. but if I took
64K x 50 x 12

That would mean that array is hoggin 38Megs of RAM??????


Thanks for info

not at all, if that array you are using is an array of variants each elemnt will take up 16 bytes, for any numeric value and 22 bytes + string length for strings. So in case you don't have variable contents of the items i suggest you use the datatype you prefer to have the items stored as.

Also, an array requires 20 bytes + 4 bytes for each dimension + the amount of data each item require

I'm running ME now (missing 2K) - so I downloading a memory tool and took a look at how much memory the application was taking up.........

It didn't look that bad at all.

Thanks,