validate all cells before save

[Guest]

i have an application that used data validation to ensure that entries into
cells are valid...duh. however, i use macros to change the values of these
cells and the validation does not get picked up. is there a way to either
have this validation work when a macro changes a cell value or, maybe even
better, run a macro before the user saves the workbook that will validate all
of the cells. are eitehr of these possible? TIA.

 

[Don Guillett]

You could do either. Have a look in the vba help index for FINDNEXT

 

[Guest]

ok...i see that i could loop through all my cells that contain data
validation, but how do i check the validity of the cells?

 

[Don Guillett]

I guess you would have to check each cell against a list.