ldy老师: 在学习了您以下的代码后 Set d("王先生") = New Dictionary d("王先生")("TEL") = "010-87654321" d("王先生")("MOB") = "13988888888" d("王先生")("QQ") = "45678900" d("王先生")("父") = "王老四" d("王先生")("子") = "王小明" '要查他的手机 MsgBox d("王先生")("MOB") 我试着编了一小段,但达不到要求 Sub test() Dim d As New Dictionary arr = [A1].CurrentRegion For i = 2 To UBound(arr) Set d(arr(i, 1)) = New Dictionary For j = 2 To UBound(arr, 2) d(arr(i, 1))(arr(1, j)) = arr(i, j) Next j Next i For i = 8 To [A65536].End(xlUp).Row Cells(i, 3) = d(Cells(i, 1))(Cells(i, 2)) Next i End Sub 红色的这一句取不到子字典的关键字(日期)所对应的数量? 可以取到吗?该如何取?
|