title: VBA memory size of Arrays and Arraylist
body: <p>I have tried to load 6.000.000 (6 mio) strings of 64 characters in length in order to sort them in VBA.
  What I have noticed is :
  1. When I use an Array the memory occupied is around 916 MB
  2. When I use an ArrayList the memory occupied goes to 1.105 MB
  None of them is reasonable to me as the strings size is around 380 MB.
  What I doing wrong ?
  As the numbers of strings will grow rapidly I will face 'Out of memory' very soon.
  Any idea will be welcome.</p>
  
  <p>Demetres</p>