Thread: Randomly generate numbers, Macro?
View Single Post
 
Old 08-11-2012, 07:09 AM
JohnWilson JohnWilson is offline Windows 7 64bit Office 2010 32bit
Programmer
  
Join Date: Nov 2008
Location: UK
Posts: 1,913
JohnWilson has a spectacular aura aboutJohnWilson has a spectacular aura about
Default
It needs a macro

To generate the random number use this formula:
Number =Int((highest number in range - one less that lowest number)*rnd + lowest number in range)
EXAMPLE number between 10 and 1000
Code:
Number=Int(991*rnd)+10 '991 is 1000 -9


__________________
Microsoft PowerPoint MVP 2007-2023
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote