Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo Box
Sub SOR()
I have a combobox - when I choose an option it arranges data according to Client which is currently in column G, however I need to sort data according to "Client" irrespective of the Column, how do I tinker with the code below to do this - Thanks The bit I think I need changing is Key1:=Range("G9") to Range("col("Client")9) or something like this Range("C9:AS69").Select Selection.Sort Key1:=Range("G9"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking a form combo box... results from the combo box to another | Excel Discussion (Misc queries) | |||
combo reference on another combo box for picking address etc. | Excel Worksheet Functions | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
"Combo Box - getting control combo box to stick in place in worksh | Excel Discussion (Misc queries) | |||
Combo Box - Hide Combo Box w/Check Box | Excel Programming |