| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Randomize the order of the contents of an array
I have a range of cells 5 * 5 (A1:E5) which have string contents in them at
present. I want to run a macro that randomly sorts the existing contents into different cells - it has to be the order of the existing content that is randomly re-ordered not the content itself. Think of it similar to a bingo card with the contents being the text strings one, two,...., twenty five - where I want to produce random outputs for printing. How would I do this in VBA. Cheers. |
| 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 | |||
Threaded Mode
