Hi, I know how to sort tables using sort, but cant figure out how to sort rows & columns using an array.
Basically I had an outerloop which held the start & end range of a column, ie c1 to c3, then an innerloop which cycled through the entire row using the starting points from the outerloop. So sort from c1 to c3, then sort d1 to d3, e1 to e3 etc.,
The outerloop then switched to the next set of starting points ie c7 to c12 & the innerloop sorts all the rows as above.
LabelPosition contains the starting point, & LoopCount contains the end point, just add the two for the total range. ie 3+3=6
ie.,
LabelPosition(8) = 3
LoopCount(8) = 3
Would equal start at c3 & end at d6. 3 +3 = 6.
I've copied the entire table to an array, but cant figure out how to sort each row & column in the array using the starting point LabelPosition & ending point in LoopCount.
Many Thanks.,
Please Login or Register to view this content.
Bookmarks