validation list. Scroll to top when using, how?
Hi
Hard to decide based on such sparse info, but probably your list source
range contains empty cells at bottom. Then when dropdown is activated for
empty cell, the (empty) bottom line of list is selected by default. Use a
dynamic range as list source, to include only non-empty entries into list.
--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )
"Corey" wrote in message
...
I have some validation lists placed on some cells.
But have noticed that due to the refernced cells being sometimes 10 cells
long, they
alway seem to open looking at the last few cells.
Is there a way to have the list scrolled to the top when clicking the
cell?
--
Regards
Corey
|