hi,

a "drop down list" can be a ComboBox control or a data validation list
or a ComboBox form, what is yours?

isabelle

Le 2013-01-30 12:22, escelnewbie a écrit :

Hello,
I need help with a sub that that will copy a name from selected drop
down list and paste it to a designated cell , but if the cell is not
blank then paste on the next cell down if blank, if not then next
down...ect. to a range of 15 cells.