Hi

Let's assume you have list values in range X1:X10
You defined your list using relative reference like
=$X1:$X10

Now, on row 2 the reference will be
=$X2:$X11
, on row 3
=$X3:$X12
, on row 11
=$X11:$X20

As you can see, the referred range 'moves off' the range with your list. To
avoid this, use absolute reference instead
=$X$1:$X$10


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"D.Farns" wrote in message
...
I'm trying to build a drop down list using the values in a range of cells
on
the same sheet. I Select about 150 cells and then using the Add method of
the Validation object to create the validation on this range of cells.
The
code runs and all 150 cells now have a drop down list. The problem is
that
the drop down list for the top cell in the range has a complete list of
values. As you go down the list of cells and click the drop down list,
the
list of values gets shorter and shorter until finally it's blank when you
get
about half way down the list of 150 cells.

The point at which the drop down list comes up blank seems to correlate to
the number of cells in the range used as the Formula1 in .Add method.

anyone seen this before or know what's going on? Love some suggestions.

thanks

--
D.Farns