Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Cell Values
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing cell values | Excel Discussion (Misc queries) | |||
changing cell values from within UDF | Excel Programming | |||
Changing cell values | Excel Programming | |||
Changing cell values | Excel Programming | |||
Changing Values In A Cell | Excel Programming |