title: Use of Vector Cross in Ms Excel - 3D arrays and Redim
body: <p>I'm facing an issue with the use of Redim in VBA of MS Excel in a 3D array. How can I append a new array with different dimension than the first one to the first array and then another one and then ...; and then be able to read a specific group of data from this newly created matrix (array) with different number of columns in each row, for example, the 2nd group of data. Here is an example to clarify the matter.</p>
  
  <ul>
  <li>Arr1 is in 3x3</li>
  <li>Arr2 is in 5x5</li>
  <li>Arr3 is in 7x7</li>
  <li>Arr4 is in 9x9</li>
  <li>Arr5 is in 11x11 dimensions.</li>
  </ul>
  
  <p>Now if I append them together the resulting matrix should be in this format - for example:</p>
  
  <p>1 2 3<br>
  4 5 6<br>
  7 8 9<br>
  1 2 3 4 5<br>
  6 7 8 9 1<br>
  2 3 4 5 6<br>
  7 8 9 1 2<br>
  3 4 5 6 7<br>
  ...<br>
  ...<br>
  1 2 3  ... 11<br>
  1 2 3  ... 11<br>
  (another 8 rows)<br>
  1 2 3  ... 11<br>
  (total of 11 rows)<br></p>
  
  <p>Next I want to be able to read a group of data (sub-matrix) from the resulting matrix, for example the 2nd group of data, which is in 5x5.
  If I use Redim in between each loop, while appending those new group of arrays and so to adjust the dimensions of the first matrix and continuing to do so, the last dimension will be in 11x11, which does not give me the needed dimension; in this case 5x5.</p>
  
  <p>I was wondering, if there is any recommendation you could kindly provide. Thank you.</p>