Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort on C not A
I have the following:
ActiveSheet.Range("Employees").Sort _ Key1:=Range("A1", "Employees"), _ Order1:=xlAscending, _ DataOption1:=xlSortNormal, _ Header:=xlNo This sorts Range: "Employees" by column "A" What do I have to change to get the range sorted by column "C" ?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort on C not A
ActiveSheet.Range("Employees").Sort _
Key1:=Columns("C"), _ Order1:=xlAscending, _ DataOption1:=xlSortNormal, _ Header:=xlNo "Helmut" wrote: I have the following: ActiveSheet.Range("Employees").Sort _ Key1:=Range("A1", "Employees"), _ Order1:=xlAscending, _ DataOption1:=xlSortNormal, _ Header:=xlNo This sorts Range: "Employees" by column "A" What do I have to change to get the range sorted by column "C" ?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating workbook with an alpha sort sheet and a numeric sort shee | Excel Discussion (Misc queries) | |||
sort function for dates does not sort properly in Office 2007 Exc. | Excel Worksheet Functions | |||
Pls. reply Sort Data and copy to next coulmn when sort order chang | Excel Programming | |||
Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
sort (on part of) string - originally posted under Tricky Sort | Excel Programming |