|
发表于 2012-8-16 20:27
|
显示全部楼层
本楼为最佳答案
- Sub a()
- Dim d As Object
- Dim i%, j%, arr, brr()
- Set d = CreateObject("scripting.dictionary")
- arr = Sheet3.Range("a1").CurrentRegion
- For i = 2 To UBound(arr)
- d(arr(i, 1)) = arr(i, 2)
- Next i
- Erase arr
- arr = Sheet2.Range("a2").Resize(Cells(Rows.Count, 1).End(3).Row - 1)
- ReDim brr(1 To UBound(arr), 1 To 1)
- For j = 1 To UBound(arr)
- brr(j, 1) = d(arr(j, 1))
- Next j
- Range("b2").Resize(UBound(brr)) = brr
- End Sub
复制代码 |
评分
-
查看全部评分
|