title: How do I get the range address of items in my array in VBA?
body: <pre><code>Sub sel_to_array()
  
      Dim arr As Variant
      Dim i
  
      Sheets("Ps").Activate
      Sheets("Ps").Range("C6").Select
      Range(Selection, Selection.End(xlDown)).Select
  
      'arr = ActiveCell.CurrentRegion.Value
      arr = Selection
  
      For Each i In arr
          MsgBox i
  
          If Round(i, 0) = Round(proj_cbox.Value, 0) Then
              GoTo 1:
          End If
  
          Next i
  
  End Sub
  </code></pre>
  
  <p>Here is what it does: when it finds the equal match, I want to know what its cell location is, for example <code>A3</code> or <code>A13</code>.</p>