|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
本帖最后由 lsc900707 于 2018-7-19 20:51 编辑
用字典处理更方便。
- Sub gj23w98()
- Set d = CreateObject("Scripting.Dictionary")
- arr = Sheet9.[a1].CurrentRegion
- For i = 2 To UBound(arr)
- For j = 2 To UBound(arr, 2)
- s = arr(i, 1) & arr(1, j)
- d(s) = arr(i, j)
- Next
- Next
- brr = [a5].CurrentRegion
- For i = 2 To UBound(brr)
- s = Split(brr(i, 1), "-")(0) & brr(i, 2)
- If d.exists(s) Then brr(i, 7) = d(s)
- brr(i, 8) = brr(i, 4) * brr(i, 7)
- Next
- [a5].CurrentRegion = brr
- End Sub
复制代码
|
|