一列里面有重复内容,想从下往上删除重复的,写了个宏运行就整列都删了,大家帮忙看看哪里的问题呢?
Sub 删重复()
h = [h65536].End(3).Row
For i = h To 2 Step -1
aa= Cells(i, "h")
hh = [h65536].End(3).Row
For ii = 2 To hh - 1
If Cells(ii, "h") = aa Then
Rows(i).Select
Selection.Delete Shift:=xlUp
Exit For
End If
Next
Next
End Sub