I have a group of merged cells named "DPU_by_Line_DropDown". It has a validation range that my code sets correctly to a list on another tab. I wrote some code trying to set this named range to be the first value in the validation rnage, which seems easy enough but isn't working.
My first step to seeing what was wrong was trying to do the process manually, and that also doesn't work, when I copy the value from the other sheet and paste in my merged cell rnage (with data validation) it does nothing. The cell just shows as blank. But I can paste it in any other cell on the sheet.
I'm curious if this is expected behavior. In a perfect world I could code the dropdown value in the merged cell (dropdown is the validation range) to be the first value in the validation list, but is that even possible. Pasting the correct value in doesn't seem to work.
My first step to seeing what was wrong was trying to do the process manually, and that also doesn't work, when I copy the value from the other sheet and paste in my merged cell rnage (with data validation) it does nothing. The cell just shows as blank. But I can paste it in any other cell on the sheet.
I'm curious if this is expected behavior. In a perfect world I could code the dropdown value in the merged cell (dropdown is the validation range) to be the first value in the validation list, but is that even possible. Pasting the correct value in doesn't seem to work.
