Random # Generator
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 |
All times are GMT +1. The time now is 05:15 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com