I am completely stuck on an issue with a Data Validation List and would very much appreciate any assistance.
I have the Data Validation List in Cell D10. When the User selects a value, I would like to copy the value to a different cell on the same worksheet (I won’t cloud the issue with why) but whenever I try Range(“G10”).value= Range(“D10”).value, nothing is returned.
As D10 is a Data Validation List, I have also tried using Range(“G10”).value=Range(“D10”).validation.value (from an example code found online) but still nothing is returned.
Is anyone able to point me in the right direction? I feel I must be missing something obvious.