Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting a sheet by VBA
Hi,
i need to sort my worksheet in my VBA code i used the code below but it doesn't work: RCnt = Cells(Rows.Count, 2).End(xlUp).Row Range("A1:Q" & Trim(Str(RCnt + 2))).Sort Key1:=Range("A2"), Order1:=xlAscending, Key2:=Range _ ("B2"), Order2:=xlAscending, Key3:=Range("E2"), Order3:=xlAscending, _ Header:=xlYes, OrderCustom:=1, MatchCase:=False, Orientation:= _ xlTopToBottom, DataOption1:=xlSortNormal, DataOption2:=xlSortNormal, _ DataOption3:=xlSortNormal any help would be appreciated. Thanks, -- Farhad Hodjat |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting a sheet by VBA
What doesn't work? It appeared to work OK for me.
"Farhad" wrote: Hi, i need to sort my worksheet in my VBA code i used the code below but it doesn't work: RCnt = Cells(Rows.Count, 2).End(xlUp).Row Range("A1:Q" & Trim(Str(RCnt + 2))).Sort Key1:=Range("A2"), Order1:=xlAscending, Key2:=Range _ ("B2"), Order2:=xlAscending, Key3:=Range("E2"), Order3:=xlAscending, _ Header:=xlYes, OrderCustom:=1, MatchCase:=False, Orientation:= _ xlTopToBottom, DataOption1:=xlSortNormal, DataOption2:=xlSortNormal, _ DataOption3:=xlSortNormal any help would be appreciated. Thanks, -- Farhad Hodjat |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting a sheet by VBA
Hi,
Thank you for your reply, it suppose to sort my sheet based on the condition i determined but nothing would happen to my sheet. Thanks, -- Farhad Hodjat "Toppers" wrote: What doesn't work? It appeared to work OK for me. "Farhad" wrote: Hi, i need to sort my worksheet in my VBA code i used the code below but it doesn't work: RCnt = Cells(Rows.Count, 2).End(xlUp).Row Range("A1:Q" & Trim(Str(RCnt + 2))).Sort Key1:=Range("A2"), Order1:=xlAscending, Key2:=Range _ ("B2"), Order2:=xlAscending, Key3:=Range("E2"), Order3:=xlAscending, _ Header:=xlYes, OrderCustom:=1, MatchCase:=False, Orientation:= _ xlTopToBottom, DataOption1:=xlSortNormal, DataOption2:=xlSortNormal, _ DataOption3:=xlSortNormal any help would be appreciated. Thanks, -- Farhad Hodjat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting a protected sheet | Excel Worksheet Functions | |||
Protect Sheet but allow sorting | Excel Worksheet Functions | |||
SORTING TO ANOTHER SHEET | Excel Discussion (Misc queries) | |||
Sorting rows to a another sheet | Excel Worksheet Functions | |||
Sorting a sheet | Excel Worksheet Functions |