Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array Randomly Sorted
I need to create a sub procedure to do this:
(1) load a range (i.e. B2:G2) of numbers from a sheet into an array. (2) randomly sort this array (3) paste this resorted array back to the original location. The range has blanks which are to be randomly sorted just like the numbers. I would really appreciate your help! Thank You |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
randomly select a cell from an array | Excel Discussion (Misc queries) | |||
First Value in Sorted Column is Not Sorted Properly | Excel Discussion (Misc queries) | |||
Randomly Re-arrange Entries in an array. | Excel Discussion (Misc queries) | |||
Can I randomly select values from an array with removal? | Excel Discussion (Misc queries) | |||
Need to randomly populate a 10x10 array of cells with 100 names - 5 people listed 20 times each... | Excel Programming |