| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need to sort an active sheet using the col of the active cell
My intent is to create a Sort Button that will read the Active Column for
sorting the ActiveSheet. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
I need to sort an active sheet using the col of the active cell
One way:
Sub SortByActiveCellColumn() Selection.Sort Key1:=Cells(2, ActiveCell.Column), _ Order1:=xlAscending, Header:=xlYes, _ OrderCustom:=1, MatchCase:=False, _ Orientation:=xlTopToBottom End Sub I assumed your data has headers. Also, you have to select the entire range you want sorted before you run this macro. Post back if you want help with refining this to work with what you actually have. HTH Otto "HamFlyer" wrote in message ... My intent is to create a Sort Button that will read the Active Column for sorting the ActiveSheet. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
I need to sort an active sheet using the col of the active cell
Maybe you can use the technique shown at Debra Dalgleish's site:
http://www.contextures.com/xlSort02.html HamFlyer wrote: My intent is to create a Sort Button that will read the Active Column for sorting the ActiveSheet. -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
I need to sort an active sheet using the col of the active cel
"Otto Moehrbach" wrote: One way: Sub SortByActiveCellColumn() Selection.Sort Key1:=Cells(2, ActiveCell.Column), _ Order1:=xlAscending, Header:=xlYes, _ OrderCustom:=1, MatchCase:=False, _ Orientation:=xlTopToBottom End Sub I assumed your data has headers. Also, you have to select the entire range you want sorted before you run this macro. Post back if you want help with refining this to work with what you actually have. HTH Otto "HamFlyer" wrote in message ... My intent is to create a Sort Button that will read the Active Column for sorting the ActiveSheet. Thanks Otto That was just the clue I needed. All the other code is in place and working. Thanks again |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
| referring to formula in a non active cell from active cell | Excel Discussion (Misc queries) | |||
| Copy from active sheet and paste into new sheet using info from cell in active | Excel Programming | |||
| sort on not active sheet | Excel Programming | |||
| If active cell found in another sheet | Excel Programming | |||
Linear Mode
