View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers
 
Posts: n/a
Default blanks in data validation list dropdown

If the source is fixed at 13 rows then use $L$1:$L$13 for the source.

"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