2,464
社区成员
发帖
与我相关
我的任务
分享
Public Sub RemoveDup()
Dim myranges As Range, nrow As Long
Set myranges = Worksheets("sheet1").UsedRange
With Worksheets("sheet2")
myranges.Copy _
Destination:=.Range("a1")
nrow = .Range("a65532").End(xlUp).Row
.Range(.Cells(1, "a"), .Cells(nrow, "D")).RemoveDuplicates Columns:=Array(2, 3, 4), Header:=xlYes
End With
End Sub