|
|
#2
08-11-2012, 07:09 AM
|
|||
|
|||
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 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Macro to recap data of same numbers | Jasa P | Word VBA | 0 | 06-28-2012 02:41 AM |
 Formatting changing randomly
|
Franuzz | Word | 1 | 07-14-2011 04:12 PM |
| black text randomly changing to white when run macro | G DeBree | PowerPoint | 0 | 03-16-2011 09:23 AM |
| Randomly delayed emails | Colinest84 | Outlook | 1 | 01-14-2011 02:32 AM |
| Documents Randomly Corrupting | the IT Guy | Word | 0 | 02-06-2009 09:11 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode