| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA sort does not work
Hi,
i have code below to sort a range in my worksheet but it doesn't work however i can sort it by manually Sheets(1).Range("A" & Trim(Str(strt)) & ":Q" & Trim(Str(endd - 1))).Select Selection.Sort Key1:=Range("A" & Trim(Str(strt))), Order1:=xlAscending, _ Header:=xlYes, OrderCustom:=1, MatchCase:=False, Orientation:= _ xlTopToBottom, DataOption1:=xlSortNormal, DataOption2:=xlSortNormal, _ DataOption3:=xlSortNormal i am stock on this problem please help. Thanks, -- Farhad Hodjat |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VBA sort does not work
sort key SHEETS
or use a with statement -- Don Guillett Microsoft MVP Excel SalesAid Software "Farhad" wrote in message ... Hi, i have code below to sort a range in my worksheet but it doesn't work however i can sort it by manually Sheets(1).Range("A" & Trim(Str(strt)) & ":Q" & Trim(Str(endd - 1))).Select Selection.Sort Key1:=Range("A" & Trim(Str(strt))), Order1:=xlAscending, _ Header:=xlYes, OrderCustom:=1, MatchCase:=False, Orientation:= _ xlTopToBottom, DataOption1:=xlSortNormal, DataOption2:=xlSortNormal, _ DataOption3:=xlSortNormal i am stock on this problem please help. Thanks, -- Farhad Hodjat |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
VBA sort does not work
Hi Don,
Thank you for your respond but i found it in the Header:=xlYes i should choos Header:=xlNo Regards, -- Farhad Hodjat "Don Guillett" wrote: sort key SHEETS or use a with statement -- Don Guillett Microsoft MVP Excel SalesAid Software "Farhad" wrote in message ... Hi, i have code below to sort a range in my worksheet but it doesn't work however i can sort it by manually Sheets(1).Range("A" & Trim(Str(strt)) & ":Q" & Trim(Str(endd - 1))).Select Selection.Sort Key1:=Range("A" & Trim(Str(strt))), Order1:=xlAscending, _ Header:=xlYes, OrderCustom:=1, MatchCase:=False, Orientation:= _ xlTopToBottom, DataOption1:=xlSortNormal, DataOption2:=xlSortNormal, _ DataOption3:=xlSortNormal i am stock on this problem please help. Thanks, -- Farhad Hodjat |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I can't get sort to work | Excel Discussion (Misc queries) | |||
| How to sort protected worksheet in Excel 07? Doesn't work. | Excel Worksheet Functions | |||
| Excel sort application should work with Project WBS | Excel Worksheet Functions | |||
| how do i sort a proceted work sheet | Excel Worksheet Functions | |||
| Sort data from 1 work sheet into another | Excel Worksheet Functions | |||
Hybrid Mode
