hey,

thanks a lot guys! it works! :) you solved my problem!

i heard from someone that its possible to do the same thing without
using VBA. by using the Validate option in the Data menu and selecting
List in the options thr. i tried tht too. but i cant put the items i
want to put in the list in the same sheet and it only allows the source
of the list to be on the same sheet. so thats a problem. is it so or i'm
making a mistake somewhr? which one is a better solution?

thanks again!!
gupt


--
gupt
------------------------------------------------------------------------
gupt's Profile: http://www.excelforum.com/member.php...o&userid=24067
View this thread: http://www.excelforum.com/showthread...hreadid=376700