Oops! Sorry for the last posting. I figured it out...an error in my spelling.
Works like a charm now.
Thanks again,
RD Wirr


"K Dales" wrote:

Dim FabCell as Range

For Each FabCell in Range("Fablist").Cells
FabCell.Value = "Choose Fab"
Next FabCell

--
- K Dales


"RD Wirr" wrote:

I have a spreadsheet with some non-contiguous cells that have dropdown
validation lists. I am trying to make a VBA routine to reset all these cells
to a default value. The cells are all part of a named range "Fablist" for
easy selection but I am having trouble finding the method to set the value in
all these cells to a specific fixed value "Choose Fab". This value is also in
the validation list. Can anyone give me a simple way to set these values?
Thanks in advance,
RD Wirr