|
本帖最后由 林木水 于 2022-1-18 17:01 编辑
- Sub demo()
- Dim i As Long, h As Long, arr, d As Object, brr
- Set d = CreateObject("scripting.dictionary")
- arr = Sheet1.Range("e2:f" & Sheet1.Range("f65536").End(xlUp).Row)
- For i = 1 To UBound(arr)
- d(arr(i, 1)) = arr(i, 2)
- Next i
- h = Sheet2.Range("c65536").End(xlUp).Row
- If h = 1 Then End
- brr = Sheet2.Range("a2:c" & h)
- For i = 1 To UBound(brr)
- brr(i, 3) = d(brr(i, 1))
- Next i
- Sheet2.Range("a2:c" & h) = brr
- End Sub
复制代码
|
|