Hi,

If you have a list of data say in column A and just after the last
entry you right click and select pick from list it shows you a list of
all the entries above

Hoe that helps


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=553839