title: VBA: reading Excel range into an object array
body: <p>How do I read an Excel range into an object array?</p>
  
  <p>To clarify, for this Excel range of 6 cells... </p>
  
  <pre><code>John    Roberts    56
  Sam     Alito      52
  </code></pre>
  
  <p>and this class...</p>
  
  <pre><code>Class supremes      
  Public firstName        
  Public lastName     
  Public age  
  Dim supreme As New supremes 
  </code></pre>
  
  <p>I'd like to read the Excel range into an array of <code>supreme</code> such that:      </p>
  
  <pre><code>arr(1).firstName = "John"   
  arr(2).age = 52 
  </code></pre>
  
  <p>For a standard array, this is done with a single assignment...</p>
  
  <pre><code>arr = range("supremes")
  </code></pre>
  
  <p>Is there a similar command to populate the object array?</p>