First post here, Looking forward to meeting new people.
Any ideas what is wrong with this code.
Any ideas what is wrong with this code.
Code:
intRow = 44
For intRow = intLastRow To intRow Step -1
intFound = Cells(intLastRow, intCol).Value
If intFound >= intFirstNum Then
If intFound <= intSecondNum Then
MsgBox intFound & " is Good to keep"
intLastRow = intLastRow - 1
Else
EntireRow.Delete
End If
Else
EntireRow.Delete
End If
Next intRow