IntroDefine and apply data validation rules to cells with ExcelApplication.
Excel Data Validation (in Excel the menu, Data > Validation...) allows you to control what kind of data can be entered into cells by creating validation rules. You can define and apply these rules with ExcelApplication.
- Template: FirstYearPayment.xlsx
- Output: DataValidation_output.xlsx