title: selecting a row in vba problem
body: <p>i am programmatically selecting a row in VBA but it is giving me a TYPE MISMATCH error on this:</p>
  
  <pre><code>Rows(Str(i) &amp; ":" &amp; Str(i)).Select
  </code></pre>
  
  <p>what am i doing wrong?</p>
  
  <pre><code>For i = 5 To 1000
      If Worksheets("5470").Cells(i, 2) = "" Then
          Rows(Str(i) &amp; ":" &amp; Str(i)).Select
          Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
          Selection.Delete Shift:=xlUp
          Exit For
      End If
  Next i
  </code></pre>