Range selection

[diblibi]

Hello world,

I am quite new to vba and I am trying to build a 3 step macro that will

1- separate values ("deconcatenate them") from a given column in a different location on the same sheet
2-Filter these values so that I get a list of unique values
3-Count the occurences of each unique value

The macro is quite simple, i actually did not write it myself except for step 2. And the glitch is in... step 2.

Please Login or Register  to view this content.

At line

Please Login or Register  to view this content.

i am returned the error "438, method does not support this object"
The thing is that i am trying to select only the non-void cells to filter them.

Big love for your help !!

[StephenR]

I'm afraid that bit of code doesn't make a lot of sense to me. What are you actually trying to achieve. Why are you doing 65000 loops before doing advanced filter?

[diblibi]

The file as it is now has 50 lines of data, but it may have 100 or 1000 in the future. I want the macro to adapt and select all the lines resulting from step 1 (hence the loop), but some of these lines will be 3-column large, while other will be 1-column large or 5-column large (hence the .EndToRight).

[StephenR]

Which cells in plain English are you trying to advanced filter? It won't work across varying numbers of multiple columns.

[diblibi]

The cells resulting from the step 1 conversion, which will spread in the range "Z3:AH65536". Some initial cells might contain up to 5 different values, so there will be 5 resulting columns at the end of step 1, other initial cells will just contain 1 value etc...

So if filtering does not work across varying numbers of multiple columns, which other function can i use ?

[StephenR]

If they're always in Z:AH, this:

Please Login or Register  to view this content.

[diblibi]

It works just fine and you are just great. I had never heard about scripting dictionnary before !
Thanks