Sorry for this.

Misread the original post and thought column C was list source.

What you need is a Dynamic Range on Sheet2 so's you can allow for increased
size.

See Debra Dalgleish's site for this.

http://www.contextures.on.ca/xlNames01.html#Dynamic


Gord

On Thu, 03 Aug 2006 12:47:57 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

You cannot have the input cell as part of the list.

If you want to use all of C as a list, put your DV input cell in D1 or any other
column.

OR you could have the input cell as C1 and the list as C2:C65536


Gord Dibben MS Excel MVP

On Thu, 3 Aug 2006 11:56:02 -0700, dakotasteve
wrote:


--I am trying to understand what I am doing wrong. I selected the entire
column C in worksheet 1 for my validation entry test. The Data validation
references the list of valid account numbers shown below, which is a range
contained in worksheet2:
10400
12200
21010
26716
29000
29037
The validation is set to reference account numbers from the above list (the
range is set up as the entire column B where this list occurs, though the
list is only 40 or so account numbers, the entire column is referenced in
case I want to add additional account numbers to the approved list at a later
date). The Data Validation tab is activated to stop and show the error alert
after an invalid entry. (I want to limit the user to selecting only those
accounts on the validation list).

My problem is when I test it, it seems to accept any account number I enter
in Cell C1 in worksheet1, without regard to the actual accounts I have set up
on my data validation list in Column B in worksheet2. There is no error
message that comes up when I enter the invalid account number, just a drop
down box that allows me to enter any number I wish. What am I doing
wrong???Any help greatly appreciated!

DakotaSteve

Gord Dibben MS Excel MVP