we can put a dropdown list to a cell reference and declare its position in the VBA code... for example


With OutMail
.To = Range("I5")