Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello,
Here is my sorting code produced by macro: Range("A1:H6895").Sort Key1:=Range("F2"), Order1:=xlAscending, Key2:= _ Range("G2"), Order2:=xlAscending, Key3:=Range("H2"), Order3:=xlAscending _ , Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:= _ xlTopToBottom, DataOption1:=xlSortNormal, DataOption2:=xlSortNormal, _ DataOption3:=xlSortNormal How can I make the Range("A1:H6895").Sort dynamic, based on the number of rows in excel sheet? Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I sort by row instead of by column? | Excel Worksheet Functions | |||
sorting more than 3 keys | Excel Discussion (Misc queries) | |||
Sort Ascending button - Excel 2003 | Excel Discussion (Misc queries) | |||
"-" ignored in sort | Excel Discussion (Misc queries) | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions |