title: Set a list in excel to an array in VBA
body: <p>I have a list in excel adn I want to make it an array to delete column names that match.  The following works:</p>
  
  <pre><code>arrColumnNames = Array("Month", "Day") 
  </code></pre>
  
  <p>However I want a dynamic list.  I have also  tried </p>
  
  <pre><code>arrColumnNames = Worksheets("List").Range("J2:J35").Value 
  </code></pre>
  
  <p>But that crashes excel.</p>
  
  <p>Thanks a lot.</p>