创建字典时遇到如下问题,请看附件。
求大神帮助。
Sub test()
Dim arr
Dim d As New Dictionary
Dim x As Integer
arr = Worksheets("数据源").Range("a2").Resize(Worksheets("数据源").Range("a1").End(xlDown).Row - 1, 3)
Debug.Print UBound(arr)
With d
For x = 1 To UBound(arr)
d.Key(arr(x, 1)) = ""
Next x
End With
End Sub
错误提示:运行时错误32811
应用程序定义或对象定义错误