title: What's the difference between "Do While" and "While" "Wend" loops?
body: <p>I've encountered a a <code>while...wend</code> loop. I'm used to the <code>Do While</code> loop, so I was wondering what the differences were between these two loops.</p>
  <p>I did some testing (code below) and both seem to give me the same results:</p>
  <pre><code>Sub test_loop_1()
  Dim i As Integer
  i = 1
  Do While i &lt; 10
      Cells(i, 1) = i
      i = i + 1
  Loop
  
  End Sub
  
  Sub test_loop_2()
  Dim i As Integer
  i = 1
  While i &lt; 10
      Cells(i, 1) = i
      i = i + 1
  Wend
  
  End Sub
  </code></pre>