VBA删除重复项,只是不是很完善,得麻烦你多点几次,直到没有重复项哦,点出来的快乐,哈哈........
Sub 删除重复()
Dim Lrow As Long
Dim I As Integer
Dim myCount
Lrow = Sheets("sheet1").[A65536].End(xlUp).Row
For I = 2 To Lrow
myCount = Application.CountIf(Sheet1.Range("A2:A" & Lrow), Sheets("sheet1").Cells(I, 1))
If myCount > 1 Then
Sheets("sheet1").Cells(I, 1).Delete
End If
Next I
End Sub
For J = 2 To LRow
'得到布尔值
myBoolean = Sheet1.Range("A" & I - 1) = Sheet1.Range("A" & I)
'值为真则进行删除
If myBoolean = True Then
Sheets("sheet1").Cells(I, 1).Delete
End If
Next J