How to sortrows in VBA, instead of Matlab?

Question

I have a question about sorting an array in VBA. Previously I programmed in Matlab and I would like to do something like: P = sortrows(P,3), but using VBA. That organizes a matrix by the 3 column.

Is it possible to do something similar in VBA?

Does anyone can help me ?

Thank u!

Augusto Mello

Try adapting Crocus Crow's answer here: http://www.vbaexpress.com/forum/showthread.php?41938-Solved-sort-multi-dimensional-array — Tim Williams, Jul 31 '14 at 16:30

score 0 · Accepted Answer · answered Jul 31 '14 at 15:59

0

Use Range.sort

Dim lastrow As Long
lastrow = Cells(Rows.Count, 2).End(xlUp).Row
Range("C" & lastrow).Sort

answered Jul 31 '14 at 15:59

lakshmen

28,346
66
178
276

Thank u for the quick reply! – Augusto Jul 31 '14 at 17:20
I have the array (1,2,3) and I would like to do a circular shift in order to obtain for example (3,1,2) or (2,3,1). In Matlab I know how to do that using the following code: Y = circshift(A,K) Can u please help me with this task? I'd appreciate any sample codes... – Augusto Aug 04 '14 at 10:37
I do not know why I can not ask. Can u help me ? – Augusto Aug 04 '14 at 12:23
http://stackoverflow.com/questions/25075742/how-to-shift-an-array-circularly-on-vba – Augusto Aug 04 '14 at 13:42
how can I get rid of them? – Augusto Aug 04 '14 at 13:51
if the qns is not answered yet, just delete the qn away.. btw i answered the qn.. – lakshmen Aug 04 '14 at 13:52

How to sortrows in VBA, instead of Matlab?

1 Answers1