|
本帖最后由 lsc900707 于 2019-1-17 14:15 编辑
- Sub aaa()
- Dim d, arr, i&, myr&, brr, j&
- Set d = CreateObject("scripting.dictionary")
- Application.ScreenUpdating = False
- myr = Sheet2.Cells(Sheet2.Rows.Count, 1).End(xlUp).Row
- arr = Sheet2.Range("a2:d" & myr)
- For i = 1 To UBound(arr)
- d(arr(i, 1)) = arr(i, 4)
- Next
- brr = [a3].CurrentRegion
- For i = 2 To UBound(brr)
- If d.exists(brr(i, 1)) Then brr(i, 6) = d(brr(i, 1))
- Next
- [a3].CurrentRegion = brr
- Application.ScreenUpdating = True
- End Sub
- Sub bbb()
- Dim d, arr, i&, myr&, brr, j&
- Set d = CreateObject("scripting.dictionary")
- Application.ScreenUpdating = False
- myr = Sheet2.Cells(Sheet2.Rows.Count, 1).End(xlUp).Row
- arr = Sheet2.Range("a2:d" & myr)
- For i = 1 To UBound(arr)
- d(arr(i, 1)) = arr(i, 4)
- Next
- brr = [a5].CurrentRegion
- For i = 2 To UBound(brr)
- If d.exists(brr(i, 4)) Then brr(i, 10) = d(brr(i, 4))
- Next
- [a5].CurrentRegion = brr
- Application.ScreenUpdating = True
- End Sub
- Sub ccc()
- Dim d, arr, i&, myr&, brr, j&
- Set d = CreateObject("scripting.dictionary")
- Application.ScreenUpdating = False
- myr = Sheet2.Cells(Sheet2.Rows.Count, 1).End(xlUp).Row
- arr = Sheet2.Range("a2:d" & myr)
- For i = 1 To UBound(arr)
- d(arr(i, 1)) = arr(i, 4)
- Next
- brr = [a4].CurrentRegion
- For i = 2 To UBound(brr)
- If d.exists(brr(i, 4)) Then brr(i, 8) = d(brr(i, 4))
- Next
- [a3].CurrentRegion = brr
- Application.ScreenUpdating = True
- End Sub
复制代码
|
评分
-
1
查看全部评分
-
|