'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:
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