Microsoft Office Forums - View Single Post - Randomly generate numbers, Macro?

Thread: Randomly generate numbers, Macro?

View Single Post

Old

08-11-2012, 12:09 PM

JohnWilson JohnWilson is offline

JohnWilson is offline

JohnWilson uses Windows 7 64bit

Windows 7 64bit JohnWilson uses Office 2010 32bit

JohnWilson uses Office 2010 32bit

Office 2010 32bit

Programmer

Join Date: Nov 2008

Location: UK

Posts: 1,914

JohnWilson has a spectacular aura about

JohnWilson has a spectacular aura about

Default

Do you mean a random choice of 30, 40, 50 etc??

Easiest way would be to gererate 3 - 12 and multiply the number generated by 10

Randval = 10 * Random(3, 12)

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

Reply With Quote