Barry,
Do you want this to be done entirely in code, or do you have a sheet that lists all the options?
Matt