| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort variable range in descending order
Code below works fine but need range to be variable. May not be R61c4
(row 61). Need to sort on whatever row lands. Sub Up_N_Fix() ' Range("D65536").Select Selection.End(xlUp).Select Range(Selection, Selection.End(xlToRight)).Select Selection.Sort Key1:="R61C4", Order1:=xlDescending, Type:=xlSortValues, _ OrderCustom:=1, Orientation:=xlLeftToRight End Sub Thanx |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code for variable sort order | Excel Discussion (Misc queries) | |||
| How to order chart in descending order of Freq? | Charts and Charting in Excel | |||
| For Each Sheet in Range - Sort Descending | Excel Worksheet Functions | |||
| How to sort worksheets in alphabetical order (descending or ascending)? | Excel Discussion (Misc queries) | |||
| Excel worksheets needs to sort ascending or descending order. | Excel Worksheet Functions | |||
Threaded Mode
