Dear all,

I created a procedure where I defined a matrix "V" with row 100 and column 6
Now I want to sort it's row according to the value of it's last column. To get this, I wanted to know how Excel does this, through recording a macro. I got following procedu

Range("A1:C16").Select
Selection.Sort Key1:=Range("C1"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal


Now I used same syntax for my problem :

Range(V).Select
Selection.Sort Key1:=Range(V(1, 6)), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

However I am getting error while executing.

Can anyone give me any idea on how exactly I should do this?

Thanks and regards,
Arun

Maybe...

Range(V).Cells(1,6) --or
Range(V).Range("F1")

HTH
Kostis Vezerides

On Jul 4, 5:59 pm, Arun Kumar Saha
wrote:
Dear all,

I created a procedure where I defined a matrix "V" with row 100 and
column 6
Now I want to sort it's row according to the value of it's last column.
To get this, I wanted to know how Excel does this, through recording a
macro. I got following procedu

Range("A1:C16").Select
Selection.Sort Key1:=Range("C1"), Order1:=xlAscending, Header:=xlGuess,
_
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

Now I used same syntax for my problem :

Range(V).Select
Selection.Sort Key1:=Range(V(1, 6)), Order1:=xlAscending,
Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

However I am getting error while executing.

Can anyone give me any idea on how exactly I should do this?

Thanks and regards,
Arun

--
Arun Kumar Saha