Changing Cell Values

[RD Wirr]

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

[K Dales]

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

[RD Wirr]

Hello K Dales,
Thanks for your help. I tried this routine you gave me stand alone (with
EndSub appended) but it generates an error>
Run-time error '1004':
Method 'Range' of object '_Global' failed

Do you have an idea of how to get around this?

Thanks again for your help
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

[RD Wirr]

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