Apr 25 2023 01:20 PM
How can one copy a cell which containing drop down list?
Apr 25 2023 01:26 PM
I presume you're looking to copy the validation list but not necessarily the value chosen from the list.
Copy the cell with the validation list.
Select the cell or range destination. Right-click | Paste Special and then select Validation.
Apr 27 2023 01:03 PM
No thanks.
In a one time case, I would simply use ctrl+C and ctrl+V to get the same drop down list in the new cell.
However, I want to compose a macro that will copy a specific cell (containing a drop down list) to any cell. I.e. staying in a cell and pushing the macro batten will do exactly the same action as a simply ctrl+C and ctrl+V dose. @Patrick2788