执行下面代码,结果会生成在sheet3中- Sub xx()
- Dim arr, n%, i%, j%, brr, crr(), r
- arr = Sheet1.Range("A1").CurrentRegion
- brr = Sheet2.Range("A1").CurrentRegion
- n = UBound(arr, 2) - 1 + UBound(brr, 2)
- r = UBound(brr, 1)
- ReDim Preserve crr(1 To r, 1 To n)
- For i = 1 To r
- crr(i, 1) = brr(i, 1)
- crr(i, n) = brr(i, 2)
- For j = 1 To UBound(arr, 1)
- If brr(i, 1) = arr(j, 1) Then
- For k = 2 To UBound(arr, 2)
- crr(i, k) = arr(j, k)
- Next
- Exit For
- End If
- Next
- Next
- Sheet3.Cells.Clear
- Sheet3.Range("A1").Resize(r, n) = crr
- End Sub
复制代码 |