Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
535
Finding cells with content
posted

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

  • 1530
    posted

    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 Tenev
    Software Developer