I have a dynamic Drop-down being populated by the Headers from Range("G1:AZ1") when a button is clicked, there could be any number of headers in this range
If there are No headers in this range i.e. all cells are empty then I need to clear the drop-down of the values it has.
But I am having...