Sorting with VB

[Tren2k]

Hi Guys

Can someone tell me how to amend the following line of code to sort by column D then by column E, ive tried variations like "sort 4 & 5" etc but cant seem to crack it

.Range("A2:AA" & iRow).Sort 4, xlAscending, xlNo

Thanks

 

[njimack]

Code generated by macro recorder gives you:
Range("A2:AA" & iRow).Sort Key1:=Range("D1"), Order1:=xlAscending, Key2:=Range("E1"), Order2:=xlAscending

 

[Andrew Poulsom]

Have you tried recording a macro while doing it manually? The syntax for the Sort method is:

Sort(Key1, Order1, Key2, Type, Order2, Key3, Order3, Header, OrderCustom, MatchCase, Orientation, SortMethod, DataOption1, DataOption2, DataOption3)

 

[Tren2k]

Thanks for the reply, I'm using a built in spreadsheet control and this method doesn't work with it.

 

[Andrew Poulsom]

Thanks for the reply, I'm using a built in spreadsheet control and this method doesn't work with it.

Why didn't you mention that at the outset? The syntax for the Spreadsheet Control's Sort method is:

Sort(ColumnKey, Order, Header)

which you already have. It doesn't cater for sorting by more than one column.

 

[Tren2k]

Why didn't you mention that at the outset? The syntax for the Spreadsheet Control's Sort method is:

Sort(ColumnKey, Order, Header)

which you already have. It doesn't cater for sorting by more than one column.

Sorry was in the middle of it and it skipped my mind, thanks for letting me know Andrew.

 

[Andrew Poulsom]

To sort by more than one column you can sort each column in reverse order of importance. It's the same as you would do if you wanted to sort by more than 3 columns in Excel:

http://support.microsoft.com/kb/268007