Highlight the whole range containing the County names, then, in the namebox,
on the left of the formula bar, (the one that says A1 if you select A1),
click it and type in the name of your choice then hit enter. You need to do
this with a list in Data Validation unless the list is on the same worksheet
as your validated entry field, it wont take a cell reference to another
sheet like Sheet3!A:A77
The advantage is that if you were using a range like A1:N87 in several
formulas, by naming the range to say 'myrange' you use that instead of
clumsy cell references and you don't need to worry about Absolute (dollar
signs) and Relative (no dollar signs) when dragging formulas down a range.
Regards,

"barryderay" wrote in message
...
Thans for the quick responce. How do I name the range?

"barryderay" wrote:

I have a field asking for a county name. There are 77 possible counties
to
enter. I want to ensure that the user enters a valid county and has it
spelt
correctly. Is there a way to do this? Can I have the validation point to
text
file with all the acceptable entries? Also is there a way to format the
cell
to convert anything entered into all upper case?