F5SpecialData ValidationOK

EditClear Contents.

If your text in the "non-data val cells in between" is derived from formulas
based upon the Data Val cells then that text will be removed also.

To retain that text you would have to copy/paste as values before re-setting
the Data Val cells to blank.


Gord Dibben MS Excel MVP


On Tue, 25 May 2010 06:05:01 -0700, Diddy
wrote:

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