title: One-dimensional array from Excel Range
body: <p>I'm presently populating my array Securities with the following code:</p>
  
  <pre><code>Option Base 1
  Securities = Array(Worksheets(3).Range("A8:A" &amp; SymbolCount).Value)
  </code></pre>
  
  <p>This produces a 2-dimensional array where every address is (1...1,1...N). I want a 1-dimensional array (1...N).</p>
  
  <p>How can I either (a) populate Securities as a 1-dimensional array, or, (b) efficiently strip Securities to a 1-dimensional array (I'm stuck at a with each loop). </p>