Thread: Sort on C not A
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Helmut Helmut is offline
external usenet poster
 
Posts: 111
Default 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" ??