title: How can I repeat code through entire data?
body: <p>I have written a few lines of code that work like I want them too but I don't know how to repeat it through all rows of my data.
  This probably seems like a rather simple thing but since I started VBA just a few days ago I struggle with this line of code</p>
  <p>If I continue with <code>ActiveCell.Offset(-1,-4)</code> after my code it's a bug and I don't know how to repeat the code through all rows.</p>
  <pre><code>Sub SelectRowsWithNoBlanks()
      Range(&quot;A2&quot;).Select
      
      If ActiveCell.Offset(0, 0).Value &lt;&gt; &quot;&quot; And ActiveCell.Offset(0, 1) &lt;&gt; &quot;&quot; And ActiveCell(0, 1) &lt;&gt; &quot;&quot; And ActiveCell(0, 1) &lt;&gt; &quot;&quot; Then
          Range(ActiveCell, Cells(ActiveCell.Row, ActiveCell.Column + 4)).Select
      End If
  End Sub
  </code></pre>