| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Populating 2 ranges with different random nums in each cell
Trying the line below to populate 2 ranges with random nums between 1-100,
but it returns the same num, albeit random, in every cell. How to tweak/enhance it so that every cell would be populated with a different random num (no duplicates)? Thanks [a1:d4,g1:h5].value = Int((100* Rnd) + 1) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Random numbers from several ranges | Excel Worksheet Functions | |||
| Help with populating new combobox with list of ranges | Excel Programming | |||
| Populating a list box with specific ranges | Excel Programming | |||
| Have column of nums, need qty of each? | Excel Worksheet Functions | |||
| Is there an example of a DB procedure that adds a col of nums | Excel Programming | |||
Threaded Mode
