Sorting variants (two dimensional)

[GeorgeIII]

Hi there,

is there an easy way to sort variants? I ve searched the internet and it seems that sorting works just with ranges

Please Login or Register  to view this content.

I have variant M with 20 rows and 4 columns and want to sort the rows according to the fourth row (from the smallest to the largest).
I tried analogical things such as:

Please Login or Register  to view this content.

which does not work.
I do not want to believe that VBA does not have any internal way (function) to solve variants sorting since it should be quite casual thing..

Moderator note: I have added code tags for you. Please refer to our rules on posting.

[bsalv]

look at
createobject("System.Collections.Arraylist") and CreateObject("System.Collections.SortedList")
or so

[GeorgeIII]

thank you, however as I have no experience with what you described, although I am searching I cannot figure out what it means. Could you please specify little bit more what I should do? :-)

[bsalv]

how does you data look like ?
Do you have an example.

[GeorgeIII]

It is numerical data in the two dimensional variant, in fact it is not important what it looks like, however here is the example:

Sub Showingexample()

Dim M As Variant
ReDim M(1 To 20, 1 To 4)
For i = 1 To 20
For j = 1 To 4
M(i, j) = Sin(i * j)
Next j
Next i

'??? M.sort ????? here I need to sort the data according to the fourth column

End Sub

If the data was written on a worksheet, I could work with sort.range which works fine, but I need to keep the data in the matrix, no way to write them out onto a sheet.

[Fotis1991]

Welcome to the forum.

Pls take some minutes to read forum rules.

In your first post there is a note from a Moderator. Don't ignore this one and of course no Moderator request in the future.!

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[Fotis1991]

mancubus

Your post does not comply with Rule 7 of our Forum RULES. Please do not ignore requests by Administrators, Moderators and senior forum members regarding forum rules.

If you are unclear about the request or instruction then send a private message to them asking for clarification. Do not post a reply in a thread where a moderator has requested an action that has not yet been complied with e.g Title change or Code tags...etc

[GeorgeIII]

Thank you very much indeed! You helped me a lot. This apparantly works as it should.

By the way - does this code also allow multiple sorting? I mean for example sorting primarily according to the fourth column, secondly according to the second column and then for example according to the third column? Is it general in this way?

[mancubus]

sorry fotis.
a quick read of posts made me miss your request.




you're welcome GeorgeIII.

re-read the post #6 by fotis and correct your post #5 by adding CODE tags around the code you posted.