I use the following to search 5000 rows and delete those that contain "YES" in column N. It is VERY VERY VERY slow, looking for optimization suggestions.
Thanks
Sub DeleteDatesNotInPool()
Application.ScreenUpdating = False
Sheets("GMS Data").Select
Cells.Select
Dim intRow As Integer
Dim intLastRow As Integer
intLastRow = Range("A" & Rows.Count).End(xlUp).Row
For intRow = intLastRow To 1 Step -1
Rows(intRow).Select
If Cells(intRow, 14).Value = "YES" Then
Selection.EntireRow.Delete
End If
Next intRow
Range("A1").Select
Application.ScreenUpdating = True
End Sub
Bookmarks