I will try out yours and see if it works for me, I know that my
algorithm does exactly what I want. The only problem is I want it to
choose the number once I enter a value into E29 and it is not doing
that. I have to edit the cell then hit enter then it will select one.
But maybe it will do this your way I will try it and post the results.

Thanks for the help


--
matty_g
------------------------------------------------------------------------
matty_g's Profile: http://www.excelforum.com/member.php...o&userid=23954
View this thread: http://www.excelforum.com/showthread...hreadid=377742