Dear Paul,
Thanks for explanation. Do me a favor.
if I select a range for example A1:A10 values in this range are
(1,2,3,4,4,6,8,8,9,10) move them in dictionary object and then loop it
through and show msgbox one by one. I want to see how it works. if
dictionary object will not take
Thanks from your instruction i came to know that it works same as
collection.
Sub Dictionary_Test()
Dim i As Integer
Dim rng As Range
Set dicobj = CreateObject(Scripting.dictionary)
Set rng = ActiveSheet.Range(A1:a10)
On Error Resume Next
For Each cell In rng
dicobj.Add cell.Value, k
-
From: Mandeep Baluja rockerna...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thursday, December 4, 2014 8:14 AM
Subject: $$Excel-Macros$$ Re: Scripting.dictionary
Thanks from your instruction i came to know that it works same as collection.
Sub
Thanks Paul for your code. Now I got your point. Vabz this is the best link
I have ever seen for VBA.
On Thursday, December 4, 2014 4:50:09 PM UTC+5:30, Mandeep Baluja wrote:
While studying I got to know that Collection is the object that can take
only unique values with the key