Prompt for Value
 

thanks Bob. I'm getting an error in your code..

if and < "" Then

Any ideas

--
halem
-----------------------------------------------------------------------
halem2's Profile: http://www.excelforum.com/member.php...nfo&userid=993
View this thread: http://www.excelforum.com/showthread.php?threadid=31376