|
发表于 2016-5-29 19:24
|
显示全部楼层
本楼为最佳答案
代码如下:- Sub xx()
- Dim i&, n&, m&, j&, x&, arr(), brr(), crr(), drr()
- With Sheet1
- n = .Cells(1, .Columns.Count).End(1).Column
- m = .Cells(3, .Columns.Count).End(1).Column
- arr = .Range(.Cells(1, 1), .Cells(1, n))
- brr = .Range(.Cells(3, 1), .Cells(3, n))
- x = 1
- For i = 1 To n
- For j = 1 To m
- If arr(1, i) = brr(1, j) Then Exit For
- Next
- If j > m Then
- ReDim Preserve crr(1 To x)
- crr(x) = arr(1, i)
- x = x + 1
- End If
- Next
- .Range("A6").Resize(1, x - 1) = crr
- x = 1
- For i = 1 To m
- For j = 1 To n
- If brr(1, i) = arr(1, j) Then Exit For
- Next
- If j > n Then
- ReDim Preserve drr(1 To x)
- drr(x) = brr(1, i)
- x = x + 1
- End If
- Next
- .Range("A8").Resize(1, x - 1) = drr
- End With
- End Sub
复制代码 |
|