Select all cells.

F5SpecialData ValidationOK

EditReplace

What: *

With: first list option

Replace all.


Gord Dibben MS Excel MVP

On Fri, 9 Jan 2009 10:07:00 -0800, FirstVette52 <(My User name is Firstvette
52, too) firstvet52@(my ISP E-mail provider is) netzero.com wrote:

I have several cells that use named lists with the Validation feature on a
form. How do I reset those cells to their first list option?

Is there a way to search the form range for validated cells and then reset
them?

Thank You for any help you may be able to give : )