Hi

I have data validation on a cell, that is taking its options from another
range of cells. This works fine, however the list is defaulting to the blank
entries. I wish it to default to the 1st option in the list.

Thanks

Nathan.