Hi All,

When I create a validation list manually, I get a message saying "Evaluating
source cause an error! Do you want to continue?". If I reply Yes, XL2003
creates the data validation list, and I can choose new values from the
validation source.
If I want to create the same validation list in VBA, I get a run-time error
message. On Error Resume Next doesn't help, it skips the .Add
Type:=xlValidateList, ... etc. line, but doesn't create the validation.
How can I tell VBA to behave itself like XL user interface?

Thanks,
Stefi