|
- Sub test()
- Dim d As Object, arr, i&, s$
- Set d = CreateObject("scripting.dictionary")
- arr = Sheets("待引用表").Range("a1").CurrentRegion
- For i = 2 To UBound(arr)
- d(arr(i, 1)) = Array(arr(i, 2), 1)
- Next
- For i = 2 To [a1].End(4).Row
- s = Cells(i, 1)
- If d.exists(s) And d(s)(1) Then
- Range(Cells(i, 1), Cells(i, 2)).Interior.ColorIndex = 6
- Cells(i, 2) = d(s)(0)
- d(s) = Array(d(s)(0), 0)
- End If
- Next
- End Sub
复制代码
引用数据至指定单元格.rar
(17.24 KB, 下载次数: 11)
|
|