Setting a default value?

G

Grace

Is there a way to set a default value in a cell? I have a
column that looks at a list of values which are stored on
a separate sheet. I would like the value to default to a
value on that list.

Thanks for your help,
Grace
 
D

Don Guillett

how about somehting like a sheet activate event where if target.address then
target=sheets("sheet1").range("a2")
 
Top