VBA RND() Function: Pick a random number

=========
QUESTION
———
How do I generate a random number between X and Y? 

 

=========
ANSWER
———
See EXAMPLES 

 

=========
EXAMPLES
——— 
Int ((999 – 100 + 1) * Rnd + 100)

would return a random number between 100 and 999

 

=========
APPLIES TO / KEY WORDS
——— 
Random Numbers 

 

=========
REF
———
http://www.techonthenet.com/excel/formulas/rnd.php

 


http://anySiteSupport.com
http://anySiteHosting.com

By | 2013-06-04T19:39:01+00:00 June 4th, 2013|Access, Computers, Documentation, Microsoft, VBA|0 Comments