Sort Specific Rows & Columns In An Array

[Genus Max]

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.

[oeldere]

NON VBA solution.

A3 =IF(B2="",A2+1,A2) and drag down.

After that sort the data with the sort function, using column A.

See the atttached file.

[Genus Max]

Thanks, but i need a vba solution, hence why i posted in the vba section...

[oeldere]

Then record the given solution.

Then you have the VBA solution.

[Genus Max]

I need to sort using arrays, if you read the actual code i posted youd realise this ...

[Bo_Ry]

I'm not sure what you want, maybe try this.

Please Login or Register  to view this content.

[jindon]

Your code is just placing C3:E7 to Ke:M7.
If you show us the result that you want, it will be clearer...