Hi!

It sounds like you want a data validation drop down list.

As the source for that list you can either enter the values in the source
box separated by commas:

Mon,Tue,Wed,Thur,Fri,Sat,Sun

Or, enter the values in a range of cells that are a single row or column:

A1 = Mon
A2 = Tue
A3 = Wed
...
A7 = Sun

Then the source would be the range A1:A7

Biff

"Stacey" wrote in message
...
Hi. I am trying to do a Validation of Data, However when I have
highlighted
my cells to validate I get this error message. "The list source must be a
delimted list, or a reference to single row or column".

Thanks.