title: Assign column to an array VBA
body: <p>I have this code. DataSet is set as a variant.</p>
  
  <pre><code>DataSet = Selection.Value
  </code></pre>
  
  <p>Works fine but is there a way I can change it to just column A, specifically cells A2 to A502? Ive tried setting that as the range but it doesn't work. It also needs to ignore blank spaces because not all of the cells will have content. I am trying to eliminate the need to highlight the cells as the entries will only be in that specific range.</p>