Unfortunally, this doesn't work for me. After I run the macro, in the cell meant to have validation options, I have only one entry, one option in one row: "A;B;C". Then if i open the data validation window manually and click the OK button, options show up split in 3 rows (A, B and C option). Do you know what might cause this issue?
That never happened to me, no idea what's the reason. Try using the exact same code in the link below and see if you get the same problem: excelmacroclass.blogspot.com/2021/11/add-unique-entries-validation-list.html
Unfortunally, this doesn't work for me.
After I run the macro, in the cell meant to have validation options, I have only one entry, one option in one row: "A;B;C".
Then if i open the data validation window manually and click the OK button, options show up split in 3 rows (A, B and C option). Do you know what might cause this issue?
That never happened to me, no idea what's the reason. Try using the exact same code in the link below and see if you get the same problem: excelmacroclass.blogspot.com/2021/11/add-unique-entries-validation-list.html
@@ExcelMacroMania thank you for a reply :)
I will try this code!