Gurus,
i was trying out dictionary to solve a problem and this error occurs. I checked out the microsoft doc but still confused. What is the problem with the debug.print here? both give me "
i was trying out dictionary to solve a problem and this error occurs. I checked out the microsoft doc but still confused. What is the problem with the debug.print here? both give me "
Runtime Code 451 Property let procedure not defined and property get procedure did not return an object"
Checking local windows I can see dictionary starts taking in values.
VBA Code:
Sub asjdiajdij()
Dim d As Object
Set d = CreateObject("scripting.dictionary")
For Each cell In Sheets("abc").ListObjects("abc").DataBodyRange.Columns(1).Cells
d(cell.Value & cell.Offset(0, 1).Value) = ""
Debug.Print d.items(1)
Debug.Print d.keys(1)
Next cell
End Sub