Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am afraid of you have to find a code for sort (for example "bubble" sort),
but you can do also like this: in VBA code put the array in the first two column of one new empty worksheet, then do sort in the worksheet and after that take the contents of the worksheet column back into the VBA array. Ivan "DJMF" wrote in message ... I have a 2 column array of numerical entries in VBA that I want to sort lowest to highest by the first column (i.e. I still want to retain the links between the values in the first and second columns, just like sorting a pair of columns in a worksheet). I'd prefer not to have to move the numbers into a worksheet to do this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
multidimensional array | Excel Programming | |||
Sort MultiDimensional Array | Excel Programming | |||
Referencing multidimensional array | Excel Programming | |||
Multidimensional Array | Excel Programming | |||
MAX of Multidimensional Array | Excel Programming |