Hi,

I'm reusing a worksheet with a mixture of data validation and data entry
cells. The data validation is based on a list and the first cell in the list
is blank.

Because the worksheet has been filled in I would like to re-set all data
without removing the text in the non-data val cells in between.

Is there any quick way to do this?

Cheers
Diddy