title: Excel VBA: "For" and "If" statement on a single line?
body: <p>Is it somehow possible in VBA to put a <code>For</code> and <code>If</code> statement in a single line?
  The closest what I could get is this:</p>
  
  <pre><code>For i = 0 To n: If a = i Then a = b
  Next i
  </code></pre>
  
  <p>If I write:</p>
  
  <pre><code>For i = 0 To n: If a = i Then a = b: Next i
  </code></pre>
  
  <p>I get the "<strong>Next without For</strong>" error.</p>