| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filling Array with uniqur random numbers
I need a code to fill up an array with UNIQUE random numbers, say 50 random numbers from 100-250 range. Ideally, I need this to be accomplished *without a Worksheet interface*. I have a long-winded-and-dirty approach that generates the random numbers on a worksheet and then have these copied into an array but this method cramps the stlye of my project. Any help will be appreciated. Myles. -- Myles ------------------------------------------------------------------------ Myles's Profile: http://www.excelforum.com/member.php...o&userid=28746 View this thread: http://www.excelforum.com/showthread...hreadid=519080 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Random Number Cell Filling | Excel Discussion (Misc queries) | |||
| help with filling in an array formula | Excel Discussion (Misc queries) | |||
| Filling an array with a Loop | Excel Programming | |||
| Non-random numbers generated by excel's data analysis random gener | Excel Worksheet Functions | |||
| Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) | |||
![Myles[_48_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
