title: define an array using 2 separate columns
body: <p>I have a table of data with many columns. I want to create an array with just the data from 2 of the columns. So far I've just been defining arrays like this.</p>
  
  <pre><code>finalrow = Sheet2.Range("A1").End(xlDown).row
  finalcolumn = Sheet2.Range("A1").End(xlToRight).column
  FTSE100 = Sheet2.Range("A1").Resize(finalrow, finalcolumn)
  </code></pre>
  
  <p>And I would really like to define it as a 2 dimensional array of the form</p>
  
  <pre><code>FTSE100 = "column A to finalrow" &amp; "column G to finalrow"
  </code></pre>
  
  <p>Unfortunately, my google-fu hasn't turned up how to define an array using 2 non-adjacent data sets. Help  or advice would be much appreciated.</p>