this answered the next question I had, thanks Dave!

"Dave Peterson" wrote:

If you're trying to make it easy to add more names to that list, then you could
use a dynamic name--one that expands and contracts with the amount of data in
that column.

See Debra Dalgeish's site for some nice tips:
http://contextures.com/xlNames01.html#Dynamic

confused wrote:

Hi,

I am uing data validation on cell A1 and choosing to allow from a list.
In the source box, I am clicking on column L (source =$L:$L). I have
selected the 'ignore blank' checkbox.

column L has 13 names. If there is something in columns A, B, C....etc in
rows 14 or greater then the dropdown list in cell A1 shows blanks along with
the names from column L.

does anyone know how I stop this happening?

Thanks for any help you cangive

--

Dave Peterson