title: VBA : Exit While in If
body: <p>Ok, probably an easy one but I'm just starting to use this language and in this piece of code :</p>
  
  <pre><code>While DATA.Cells(1, i).value &amp; "" &lt;&gt; ""
      If InStr(DATA.Cells(1, i).value, columnName) &gt; 0 Then
          column = i
          Exit While
      End If
      i = i + 1
  Wend
  </code></pre>
  
  <p>It looks like it's not the way to use Exit While ? How should I do it then ?</p>