I'm trying to create a picklist of values to select from and running into
issues. I defined the values I want to choose from on a separate worksheet
in the some workbook and assigned it a name. When I go to the worksheet
where I want to access the picklist, I did the following:

Data Validation

In the allow section, I selected "List" and in the source field, entered the
name of the range I had defined. Excel is only displaying the name of the
range that I entered, not the actual values I need. Any thoughts???

Thanks,

Darren