|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub test()
- Dim r%, i%
- Dim arr, brr
- Dim d As Object
- Set d1 = CreateObject("scripting.dictionary")
- Set d2 = CreateObject("scripting.dictionary")
- arr = [{"武汉",1000;"苏州",2000;"福州",300;"广州",400}]
- brr = [{"武汉",400;"福州",300}]
- For i = 1 To UBound(arr)
- d1(arr(i, 1)) = arr(i, 2)
- Next
- For i = 1 To UBound(brr)
- d2(brr(i, 1)) = brr(i, 2)
- Next
- With Worksheets("sheet1")
- m = 1
- For Each aa In d1.keys
- m = m + 1
- .Cells(m, 1) = aa
- .Cells(m, 2) = d1(aa)
- If d2.exists(aa) Then
- .Cells(m, 3) = d2(aa)
- End If
- Next
- End With
- End Sub
复制代码 |
|