Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save danwagnerco/49161461755e04d0508a to your computer and use it in GitHub Desktop.
Save danwagnerco/49161461755e04d0508a to your computer and use it in GitHub Desktop.
This For loop deletes rows where the cell value is less than 50 (but slowly)
Option Explicit
Public Sub DeleteRowsLessThanFiftySlowly()
Dim lngIdx As Long
For lngIdx = 100000 To 1 Step -1
If Cells(lngIdx, 1).Value < 50 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