Sort

[dje71183]

I am trying to sort in excel using VBA.

My code is

 Worksheets("Information").Range("N69:R1500").Sort _
    Key1:=Worksheets("Information").Range("R1500"), _
    Key2:=Worksheets("Information").Range("O69")

Problem is that its starts at the N,1500 and moves up to 1499, 1498, and so on. I would like it to start at N,69 then move down to n,70 N,71 and so on.

Any help would be awesome,
Daniel

 

[handleman]

Do you mean that you want to switch from ascending order to descending order? If so, use

Worksheets("Information").Range("N69:R1500").Sort _
    Key1:=Worksheets("Information").Range("R1500"), _
    Order1:=xlDescending, _
    Key2:=Worksheets("Information").Range("O69")

or

Worksheets("Information").Range("N69:R1500").Sort _
    Key1:=Worksheets("Information").Range("R1500"), _
    Order1:=xlAscending, _
    Key2:=Worksheets("Information").Range("O69")

 

[dje71183]

I want my results to start on cell N69. Doestn matter Ascending or Descending..

 

[handleman]

So... are you saying that your unsorted data does not reach to row 1500 and when you sort the data it sorts blank cells to the top?

 

[dje71183]

Thats what im trying to say, thank you.

 

[dje71183]

I found my problem.

Worksheets("Information").Range("N69:R1500").Sort _
    Key1:=Worksheets("Information").Range("N69"), _
    Order1:=xlDescending, _
    Key2:=Worksheets("Information").Range("R1")

thanks.