It seems that to change the IgnoreBlank property of the Validation object for
a cell, you need to delete and recreate the whole Validation object.

Is that true?

I want to make the user select something from the dropdown sometimes, but
other times he can either select something or enter his own information.

Thanks in advance.