I'm trying to use Validation on Sheet 1 to create a list. The data for the
list is on Sheet 2.

I've assigned the name "States" to the column on Sheet 2 that contains the
data for the list.

On Sheet 1, when using Validation for the list, when I enter "=States" in
the Source box, it says "A named range you specified cannot be found".

I tried entering = and then clicking on the tab for Sheet 2 but it won't let
me do that.

I'm probably missing something really simple.

Thanks in advance.

How did you define the named range("States")?

Type "States" (no quotes) in the 'Name box' (where the cell address
appears) and hit enter. It should select the 'States' range.

HTH

"Steve Z" wrote:

I'm trying to use Validation on Sheet 1 to create a list. The data for the
list is on Sheet 2.

I've assigned the name "States" to the column on Sheet 2 that contains the
data for the list.

On Sheet 1, when using Validation for the list, when I enter "=States" in
the Source box, it says "A named range you specified cannot be found".

I tried entering = and then clicking on the tab for Sheet 2 but it won't let
me do that.

I'm probably missing something really simple.

Thanks in advance.

On Sheet 2, I've listed the states in Column A. I highlighted Column A and
in the Name Box I typed States. It accepted it fine.

That did it. I was naming the range in the box where the font is shown
instead of the box where the cell address appears.

Thanks for your help Toppers.

"Toppers" wrote:

How did you define the named range("States")?

Type "States" (no quotes) in the 'Name box' (where the cell address
appears) and hit enter. It should select the 'States' range.

HTH

"Steve Z" wrote:

I'm trying to use Validation on Sheet 1 to create a list. The data for the
list is on Sheet 2.

I've assigned the name "States" to the column on Sheet 2 that contains the
data for the list.

On Sheet 1, when using Validation for the list, when I enter "=States" in
the Source box, it says "A named range you specified cannot be found".

I tried entering = and then clicking on the tab for Sheet 2 but it won't let
me do that.

I'm probably missing something really simple.

Thanks in advance.