title: Excel VBA Use Offset to Move To Next Row
body: <p>I want to place results in successive rows using the offset property if possible.</p>
  
  <p>Line 9 is where I am having trouble getting the correct syntax.</p>
  
  <pre><code>Set startcell2 = Worksheets("Duplicates").Cells(1, 1)
  
  rs.Open "Select dmdrawno From webprddt1.drawmstrp Where dmdrawno = '" &amp; dwgno &amp; "'", oConn, adOpenKeyset, adLockOptimistic
  
  If Not rs.EOF Then
      'addnewrecord = False
  Else
      startcell2.Value = dwgno
      startcell2.Offset(1, 0)
      addnewrecord = False
  
  End If
  
  rs.Close
  Set rs = Nothing
  </code></pre>