I have a shared excel file that is running the following code:
DestSht.Range("N9", "N" & LastRwEnd).Select
With Selection.Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="=$O$2:$O$4"
.IgnoreBlank = True...