title: excel VBA using Range() and ActiveCell.Offset()
body: <p>I'm using excel VBA and I'm trying to increment a Range selection in a loop. </p>
  
  <pre><code>Sub sorter()
  Dim i As Integer
  Dim copyLoc As String = "E1"
  
  For i = 0 To 5
  Range(copyLoc).Select '//what type is Range() supposed to take?
  Selection.Copy
  copyLoc = ActiveCell.Offset(0, 6) '//what type does ActiveCell.Offset return?
  Next i
  End Sub
  </code></pre>
  
  <p>I'm sure the problem is with the data type that ActiveCell.Offset is returning. Can anyone tell me what I should use instead? Thanks kindly! </p>