Code:
'Step Through Rows Backwards and Delete Matching Data
For MyRow = LastRow To 3 Step -1
If (Cells(MyRow, "K") = Cells(MyRow - 1, "K")) Then
Rows(MyRow - 1 & ":" & MyRow).Delete
End If
Next MyRow
Hello All, the above code is working good for me to find and delete the rows with matching numbers.
I want to shift gears and delete rows that Do Not have the following Date / Time format in Column G:
mm/dd/yyyy 00:00:00
If a row has a Date / Time format in coloumn G other than the above, that row would be deleted.
I'm not having luck trying to get the code to work based on my loop example above
Thanks for the help