|
本帖最后由 乐乐2006201506 于 2017-10-19 21:50 编辑
自己调试并稍微一下,应该就可以了。
Sub test()
Dim arr, ir&, i&, x1$, crr(), ic%, j%, Q&
arr = Range("a1").CurrentRegion
ir = UBound(arr): ic = UBound(arr, 2)
'--------------------------------------------------
Dim d As Object
Set d = CreateObject("scripting.dictionary")
ReDim crr(1 To ir, 1 To ic)
'--------------------------------------------------
For i = 1 To ir
x1 = arr(i, 1) & arr(i, 2) & arr(i, 3)
If d.exists(x1) = False Then
Q = Q + 1
For j = 1 To ic
crr(Q, j) = arr(i, j)
Next j
d(x1) = 0
End If
Next i
'--------------------------------------------------
If Q > 0 Then
Workbooks.Add
Range("A1").Resize(Q, ic) = crr
End If
End Sub |
|