Hi all,
Is there any method of code to select the first one in the list of data
in a dropdown list. Ie, suppose, there are 10 contents in the dropdown
of the filter. I do not need to select actual word, rather, i need a
code which selects anything which exists in the list of dropdowns.
Please let me know the method as this should work in Macros and should
help in recording. :)
Thanks.

Signature
praveen_khm
Dave Peterson - 18 Jan 2006 15:39 GMT
You can get your own list using the technique that John Walkenbach shows at:
http://j-walk.com/ss/excel/tips/tip47.htm
He even has a sort routine in there if you need it.
> Hi all,
>
[quoted text clipped - 12 lines]
> praveen_khm's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30364
> View this thread: http://www.excelforum.com/showthread.php?threadid=502457

Signature
Dave Peterson