Need help to Create a drop-down list from a range of cells.

SORRY FOR THE DOUBLE POST BUT I READ THAT THIS FORUM IS THE BEST
REALY NEED HELP TO
Create a drop-down list from a range of cells. ?

In workbook "sheet2"
From A1 to A7 I have Monday to sunday
I highlighted these 7 fields and defined the "NAME" for the list as "=weeks"
(no quotes)

I then went to
"sheet1" and I select the field in which I want the dropdown selection

On the Data menu, i click Validation, and then click the Settings tab.
In the Allow box, click List.
To specify the location of the list of valid entries, I did the following:


The list is on a different worksheet in the same workbook , so I entered the name that I defined (=weeks) for my list in the Source box.

I then get a message, THE NAMED RANGE YOU SPECIFIED CANNOT BE FOUND.

Any help please

Hi,

Watch this apparent paradox ...

1. When defining the range name

DO NOT USE the sign =

2. In the Data Validation List Source area

DO NOT FORGET TO USE the sign =


HTH
Carim