Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Here's a sort macro I recorded. It works, but I'd like to change it to where the bottom row it goes to (the column value is constant) is the last row with content in column A. ================================ Sub Hospital_Sheet_Sort() ' ' Hospital_Sheet_Sort Macro ' Macro recorded 3/19/2005 by Randy Starkey ' ' Range("A3:V361").Select Range("V361").Activate Selection.Sort Key1:=Range("A3"), Order1:=xlAscending, Key2:=Range("N3") _ , Order2:=xlDescending, Header:=xlNo, OrderCustom:=1, MatchCase:=False _ , Orientation:=xlTopToBottom, DataOption1:=xlSortNormal, DataOption2:= _ xlSortNormal Range("A3:A3").Select End Sub ================================= Could someone help me making that adjustment? Thanks! --Randy Starkey |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sort Macro | Excel Discussion (Misc queries) | |||
Sort Macro | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Using Macro to sort without clicking on macro button | Excel Discussion (Misc queries) | |||
Sort Macro | Excel Discussion (Misc queries) |