|
请问,代码中红色部分这种写法是什么意思?是两个值连接吗?
Sub lx()
Dim d As Object, x%, ar, y%, A As Variant
Set d = CreateObject("scripting.dictionary")
ar = [a1].CurrentRegion
For x = 2 To UBound(ar)
If Not d.exists(ar(x, 1)) Then Set d(ar(x, 1)) = CreateObject("scripting.dictionary")
d(ar(x, 1))(ar(x, 2)) = ""
Next
For Each A In d.keys
y = y + 1
Cells(y + 1, "G") = A
Cells(y + 1, "H") = Join(d(A).keys, ",")
Next
End Sub
|
|