title: delete every n rows in excel with VBA
body: <p>I have a data set in excel with measurements taken every 15 minutes (one measurement one row), where I would like to keep only the ones taken on a full hour and delete the rest. In other words: I would like to keep the first row, delete the next three, keep the 5th row, delete the next three and so on.
  I would like to use VBA but I'm completely new to this.
  I've found this macro here, which deletes every four rows</p>
  
  <pre><code>Sub remove_rows()
  Dim x As Long
  Application.ScreenUpdating = False
  
  For x = 100 To 1 Step -5
      Range(x &amp; ":" &amp; x - 3).EntireRow.Delete
  Next x
  
  Application.ScreenUpdating = True
  End Sub
  </code></pre>
  
  <p>(Source: <a href="https://stackoverflow.com/questions/48813698/delete-every-four-rows-in-excel">Delete every four rows in excel</a>)
  How do I change it to delete only every three rows? I have to do the same with a dataset with measurements taken every 5 minutes (keep the 1 row, delete the next eleven, keep the 12th and so on). Is this macro good for this dataset as well? And lastly - is using VBA the best solution for this problem or is there another method which is better? The datasets are fairly big (100k+ rows).</p>