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?
@ExcelMacroMania
10 ай бұрын
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
@nikolastamenkovic7069
10 ай бұрын
@@ExcelMacroMania thank you for a reply :) I will try this code!
Пікірлер: 3