Can someone write me a visual basic code that will do the following on a
spreadsheet that already has data?

A column for "Tube Type" default is SST (this is in a validation list), how
can I change the entire spreadsheet to automatically default to from "SST" to
"Green" (the word, not the color) rather than SST. So rather than all the
columns taht default to SST, I want them to automatically default to Green.
I tried everything I can think of but someone said I probably need a visual
basic code to do, HELP!!

Rhonda Randolph
Medical University of South Carolina