|
确实是我搞错了,谢谢提醒!!
直接用数组也可以完成
- Sub test1()
- Dim arr, brr, i, crr(), j, k
- Dim dic
- Set dic = CreateObject("scripting.dictionary")
- arr = Sheets("表一").UsedRange
- brr = Sheets("表二").UsedRange
- For i = 1 To UBound(arr)
- For j = 1 To UBound(brr)
- If arr(i, 1) = brr(j, 1) And arr(i, 2) = brr(j, 2) Then
- k = k + 1
- ReDim Preserve crr(1 To 2, 1 To k)
- crr(1, k) = arr(i, 1)
- crr(2, k) = arr(i, 2)
- End If
- Next
- Next
- With Sheets("表三")
- .Cells.ClearContents
- crr = Application.Transpose(crr)
- .Cells(3, 2).Resize(UBound(crr, 1), UBound(crr, 2)) = crr
- End With
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|