Hello,
I am trying to create a data validation drop down. To a named range.

Range(strRange).Select
Range(strRange).Validation.Delete
Range(strRange).Validation.Add Type:=xlValidateList,
AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="=" &
strNamedRange



However the named range has not yet been created.
Is there a way to assign the data validation. Then later create the range.
and fill the range.
then somehow do an update to the validation?

thanks