title: ReDim existing array with a second dimension?
body: <p>I declared an array in my VBA function that has a dynamic size. As I cannot ReDim the first dimension of a two- or more-dimensional array, can I add a second dimension to a set array?</p>
  
  <p>This is how I dynamically set the size of my array.</p>
  
  <pre><code>Dim nameArray() As String
  Dim arrayCount As Long
  
  For i = 1 To 100
      ReDim Preserve nameArray(1 to arrayCount)
      nameArray(arrayCount) = "Hello World"
      arrayCount = arrayCount + 1
  Next i
  </code></pre>
  
  <p>Now I would like to add a second dimension.</p>
  
  <pre><code>ReDim Preserve nameArray(1 To arrayCount, 1 To 5)
  </code></pre>
  
  <p>doesn't work.</p>
  
  <p>Is there a workaround?</p>