Sub 删除重复与空白()
With ActiveSheet
Row0 = .Cells(1048576, 1).End(xlUp).Row
For i = Row0 To 1 Step -1
If .Range("A" & i) = "" Then
.Range("A" & i).Delete Shift:=xlUp
End If
If Application.WorksheetFunction.CountIf(Range("A1:A" & i), Range("A" & i)) > 1 Then
.Range("A" & i).Delete Shift:=xlUp
End If
Next i
End With
End Sub
Sub 删除重复与空白()
With ActiveSheet
Row0 = .Cells(1048576, 1).End(xlUp).Row
For i = Row0 To 1 Step -1
If .Range("A" & i) = "" Then
.Range("A" & i).Delete Shift:=xlUp
End If
If Application.WorksheetFunction.CountIf(Range("A1:A" & i), Range("A" & i)) > 1 Then
.Range("A" & i).Delete Shift:=xlUp
End If
Next i
End With
End Sub