title: Dynamically Dimensioning A VBA Array?
body: <p>Why am I unable to set the size of an array based on a variable?  What's the best way around this?</p>
  
  <pre><code>Dim NumberOfZombies as integer
  NumberOfZombies = 20000
  Dim Zombies(NumberOfZombies) as New Zombie
  </code></pre>