title: Excel vba - combine multiple arrays into one
body: <p>If I have 5 arrays that have same dimension, can I combine them into one array with 5 subarrays.</p>
  
  <pre><code>va = ws1.Range("A2", ws1.Cells(Rows.Count, "A").End(xlUp)).Value   
  vb = ws1.Range("D2", ws1.Cells(Rows.Count, "D").End(xlUp)).Value    
  vc = ws1.Range("F2", ws1.Cells(Rows.Count, "F").End(xlUp)).Value    
  vd = ws1.Range("C2", ws1.Cells(Rows.Count, "C").End(xlUp)).Value    
  ve = ws1.Range("E2", ws1.Cells(Rows.Count, "E").End(xlUp)).Value
  </code></pre>
  
  <p>Can I do this:</p>
  
  <pre><code>ReDim vx(1 To UBound(va, 1), 1 To 5, 1 To 1)
  vx(1,1,1) = va
  vx(1,2,1) = vb
  vx(1,3,1) = vc
  vx(1,4,1) = vd
  vx(1,5,1) = ve
  </code></pre>
  
  <p>Or do I have to do it one element by one?</p>