Checking entire row for duplicates
 

See if the first tip at this link helps you out.

http://j-walk.com/ss/excel/eee/eee016.txt

Mark


"SHiggins" wrote in message
...
I am trying to remove duplicates in my data where the entire row matches
the one under it. So far I have it where it checks just one cell to see if
it matches. How do I have it look at the entire row?

Thanks!

Here is my code so far:

Sub Dups()
Do
If ActiveCell.Value = ActiveCell.Offset(1, 0).Value Then
'ActiveCell.EntireRow.Delete
ActiveCell.Offset(1, 0).EntireRow.Delete
Else
ActiveCell.Offset(1, 0).Activate
End If
Loop Until ActiveCell.Value = Empty
End Sub