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…...validation area of cells CellArea area; area.StartRow = 0; area.EndRow...EndRow = 9; area.StartColumn = 0; area.EndColumn = 0; // Add the...