The data validation example at Data Validation|Documentation has the following line:
Validation validation = validations[validations.Add(ca)];
However, this doesn’t compile, as there is no ValidationCollection.Add that…...should first create a CellArea object, and then use the Add method...Validations; // Create a validation object by adding to the collection...