none
Check if the values in the cells are valid RRS feed

  • Question

  • Hello,<o:p></o:p>

    I have a workbook which contains cells with data validation applied. But sometimes other users paste values which are not from the list of valid values.<o:p></o:p>

    I'm looking for a macro which is able to look through all cells with validation applied on a certain worksheet and check if the values in the cells are valid according to the current cell validation.<o:p></o:p>

    If the macro finds a cell with invalid value (value which is not chosen from the list of valid values), it should open a message box with a warning and the cell address.<o:p></o:p>

    Thank you in advance for any hints! <o:p></o:p>



    Thursday, April 21, 2016 8:54 AM

Answers