To keep the numbers from regenerating here is what I did. After the
random number is put into it's place, activecell.copy the cell then
paste special pasting only the value. I can't recall the code off the
top of my head right now but that is something that can be done using
the recorder.


--
vamosj
------------------------------------------------------------------------
vamosj's Profile: http://www.excelforum.com/member.php...fo&userid=8695
View this thread: http://www.excelforum.com/showthread...hreadid=266491