title: Excel vba - access element of a range
body: <p>new to vba, and wonder how to address elements within a range.
  I add range  of cells (rows) indexed with an id to a dictionary</p>
  
  <pre><code> Set spRange = import.Range("A2:" &amp; spRange.End(xlDown).Address)
      For Each cell In spRange
          dict.Add cell.Offset(0, 2).Text, cell.Row
  
  Next cell
  </code></pre>
  
  <p>later on, I retrieve the row, and need to access value of first element.</p>
  
  <pre><code>For Each x In dict
          Set spRange = dict.Item(x)
          'how to get value of first element of spRange 
  Next
  </code></pre>
  
  <p>It could be very easy for u, but i am not familiar with api :-)</p>
  
  <p>thanks</p>