| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to leave Selection.Sort Key open....
Any way to change the sort key to be wherever cell it lands on in column C? Not limited to row number 73,74..... Sub Macro1() LastRowColA = Range("c65536").End(xlUp).Row Range(Selection, Selection.End(xlToRight)).Select Selection.Sort Key1:="R74C3", Order1:=xlDescending, Type:=xlSortValues, _ OrderCustom:=1, Orientation:=xlLeftToRight End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I toggle between 2 open excel files and leave both open | Excel Discussion (Misc queries) | |||
| Can I use Sort to alphabetize & leave blank row bet. rows (2003) | New Users to Excel | |||
| How do I sort collumns and leave out pictures in rows not used? | Excel Worksheet Functions | |||
| How do I sort values only, and leave formats? | Excel Programming | |||
| Can I sort values only & leave orginal cell formatting? | Excel Discussion (Misc queries) | |||
Threaded Mode
