Where do the FALSE items come from?

You can use dynamic ranges in both your original data set (where you're
extracting the uniques from) and then as the source (the extracted uniques
list) for the drop down list.

If you're interested I can put together a sample file that demonstrates
this.

Biff

wrote in message
oups.com...
I am also not familiar with VBA. Thanks to your code I now have my
excel sheet working. It is not perfect but it will have to do. I had
to do an itermediate step to get the unique data into a validation
select box. First I used your code to get me all the uniques from an
array and then I put the unique list into a validation select box.
This still has it's problems. I made the array longer than was needed
before I gave it to the select box in case there was any additional
records added in the future. This takes care of what I wanted to make
the worksheet do but it has alot of blanks and 'FALSE' items solely
there for expansion. Do you know how to change the function to return
as a blank field if there are no more unique items available instead of
returning 'FALSE'.

Thank you for your time.

Jeff