Hi Team,
I am trying to understand one dictionary Line. Below is the line,
How to Read it. It is used to highlight duplicate values.
d(Cells(i, 1).Value) = d(Cells(i, 1).Value) + 1 ...... what this line does.?....
Thanks
mg
I am trying to understand one dictionary Line. Below is the line,
How to Read it. It is used to highlight duplicate values.
d(Cells(i, 1).Value) = d(Cells(i, 1).Value) + 1 ...... what this line does.?....
VBA Code:
Set d = CreateObject("Scripting.Dictionary")
For i = 2 To 7
d(Cells(i, 1).Value) = d(Cells(i, 1).Value) + 1 'Add comment.
Next i
For Each itm In d.Keys
If d(itm) = 1 Then d.Remove itm
Next itm
Thanks
mg