|
Sub Click()
Dim A, B, C, d
Dim i, j, s, t$
A = Range("b2").CurrentRegion
B = Range("b9").CurrentRegion
ReDim C(1 To UBound(A), 1 To UBound(A, 2))
Set d = CreateObject("scripting.dictionary")
'1)增加A
For j = 1 To UBound(B, 2)
t = ""
For i = 1 To UBound(B)
t = t & "," & B(i, j)
Next i
' t = t & "|" & j
d(t) = t
Next j
'2)去除
For j = 1 To UBound(A, 2)
t = ""
For i = 1 To UBound(A)
t = t & "," & A(i, j)
Next i
'如果A这5个元素,不是B的,就放到C
If d.exists(t) = False Then
s = s + 1
For i = 1 To UBound(C)
C(i, s) = A(i, j)
Next i
End If
Next j
'3)输出
Rows("16:20").ClearContents
[b16].Resize(UBound(C), UBound(C, 2)) = C
End Sub
4-2B.rar
(55.96 KB, 下载次数: 3)
|
|