title: VBA adding to array at runtime
body: <p>I am trying to create an int array at runtime from results of a record set.</p>
  
  <pre><code>Do While Not rstSearchResult.EOF
  
   If rstSearchResult(ID) = blah Then 
    'Add this Id rstSearchResult(ID) to Array
   End If
  
   Call rstSearchResult.MoveNext()
  Loop
  </code></pre>
  
  <p>What I need is that same result as this will give me <code>Array(35588, 35589, 35595)</code></p>