title: Get specific item in a range
body: <p>This is my code:</p>
  <pre><code>    Debug.Print &quot;Full range: &quot; &amp; searchResult.Address
      Debug.Print &quot;Size of range: &quot; &amp; searchResult.Count
      Dim cell As Range
      For Each cell In searchResult
          Debug.Print &quot;from for each: &quot; &amp; cell.Address
      Next cell
      Debug.Print &quot;from item 0: &quot; &amp; searchResult.item(0).Address
      Debug.Print &quot;from item 1: &quot; &amp; searchResult.item(1).Address
      Debug.Print &quot;from item 2: &quot; &amp; searchResult.item(2).Address
  </code></pre>
  <p>This is my output:</p>
  <pre><code>Full range: $M$125,$M$148,$M$161
  Size of range: 3
  from for each: $M$125
  from for each: $M$148
  from for each: $M$161
  from item 0: $M$124
  from item 1: $M$125
  from item 2: $M$126
  </code></pre>
  <p>The for each is giving me the result I want, while the &quot;item&quot; give just the next item within the worksheet, not into that range.
  I just want to get the address of a specific item in that range. Let's say something like &quot;searchResult(2).address = $M$161&quot; (in case it's 0-based) like you would access items in an array.
  I'm sure it's very simple but can't find what's the name of the property I need to use...
  Thanks for your help.</p>