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

--
Don Guillett
SalesAid Software

"Spencer" wrote in message
...
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.