Thanks for the feedback although it doesn't completely work as my list
with the values for the drop down is linked to another spreadsheet, so
values from say F51 to F60 are zeros. These zeros appear in the drop
down list as well and even when I alter the formula to hide zero
values, the drop down list shows them a blank options in the drop
down list. I am using Excel 97 by the way.