Hi,
I need to find certain cells with content from a workbook (specifically ones containing data validation input messages). Is there any other way than to iterate over every cell?
Thanks,
Antti
Hi Antti,
You can obtain all cells which contains data validation input messages from the DataValidationRules collection of the Worksheet
xamSpreadSheet1.ActiveWorksheet.DataValidationRules
If you require any further assistance on the matter, please let me know.
Sincerely,Teodor TenevSoftware Developer