Sub 复制与唯一值()
Sheet5.Range("A:D").ClearContents
Sheet5.Select
Sheet7.Range("F1:F65536").Copy
Sheet5.Range("C1").Select
Sheet5.Paste
Application.CutCopyMode = False
Sheet7.Range("H1:H65536").Copy
Sheet5.Range("B1").Select
Sheet5.Paste
Application.CutCopyMode = False
Sheet7.Range("X1:X65536").Copy
Sheet5.Range("A1").Select
Sheet5.Range("A1").PasteSpecial xlPasteValues
Application.CutCopyMode = False
Dim X As Integer
X = [A65536].End(xlUp).Row
Sheet5.Range("A1:A" & X).AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range( _
"D1"), Unique:=True
Sheet4.Select
End Sub
sheet5要在活动状态才能购select吧