Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save danwagnerco/9686676c94bd01f3b38d to your computer and use it in GitHub Desktop.
Save danwagnerco/9686676c94bd01f3b38d to your computer and use it in GitHub Desktop.
This For loop deletes rows where the cell value is more recent than February 1st, 2013 (but slowly)
Option Explicit
Public Sub DeleteDatesMoreRecentThanFebFirstSlowly()
Dim lngIdx As Long
For lngIdx = 1000000 To 1 Step -1
If Cells(lngIdx, 1).Value > DateValue("2/1/2013") Then
Cells(lngIdx, 1).EntireRow.Delete
End If
Next lngIdx
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment