Validation List - Reset to Top Value?

[Guest]

Hello,

If you have a blank cell, and put validation on the cell, when you select
the dropdown list, it goes to the blank at the bottom of the list. Is there
any way force it to go to the top of the list, without selecting the top
item?
It's really annoying for users to have to scroll up every time they click on
a blank cell that has validation on it.

This would seem fairly straightforward, but I can't find a property of the
..Validation object to do it.

Thanks.

 

[Guest]

Doh, figured it out.
Just placed a space at the top of each named range used in the validation.
*slaps himself*
Apologies.