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