| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Randomize the order of the contents of an array
While John's excellent routine will work very well, the OP would
have to have a copy of his book in order to use your reply. I realize that everyone *should* have a copy, of course... In article , Michael Bednarek wrote: "Excel 2002 Power Programming with VBA", John Walkenbach, p.342: "Randomizing a range" "The RANGERANDOMIZE function ... accepts a range argument and returns an array that consists of the input range - in random order." |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| does an array contain contents of cell | New Users to Excel | |||
| search an array in reverse (bottom to top) order | Excel Discussion (Misc queries) | |||
| arrange contents of a table in Alphabetical order in excelsheet | Excel Worksheet Functions | |||
| Transpose and order array numbers | Excel Worksheet Functions | |||
| How do I lookup a value in a array that is not in ascending order | Excel Worksheet Functions | |||
Hybrid Mode
