Hi
this would be only possible using VBA

--
Regards
Frank Kabel
Frankfurt, Germany
"g" schrieb im Newsbeitrag
...
How do I set a default value in certain cells? The cells are already
validated and I would like to have the default value be one of the
validation
values.