Create validation list of distinct values

[YasserKhalil]

Hello everybody
I have three columns A - B - C with values ..
I want in Range("E1") to create validation list of distinct values of the three columns using vba ??

[YasserKhalil]

I tried this code

Please Login or Register  to view this content.

But It doesn't work for me .. I don't know why?

[Debraj Roy]

Try this one..

Please Login or Register  to view this content.

[YasserKhalil]

Thank you very much Mr. Debraj Roy
You are very helpful