Creating a dictionary of all the values from a column

[sinz0000]

there is going to be a data in A column of current sheet containing unique values. I want to add all these already existing unique values to a dictionary and use each of the unique value as a criteria for filtering in next sheet.

How to add all the values of A column to the dictionary? and how to refer to each of the value in it?

 

[Peter_SSs]

The default value of a numerical variable is zero, so that is where r starts.

The dictionary Items are as shown in column G of post 16. So for example ";P1;P2;P3"
If we create an array by splitting that on the semicolons, the first element in the array will be empty, being what is to the left of the first semicolon
Mid(";P1;P2;P3", 2) becomes "P1;P2;P3"
Now when split that string we get the three items we would expect.

 

[sinz0000]

Thank you Sir, understood now.