Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort in excel (office xp)
I am trying to get column H to sort as the others are doing using a
macro (see below). Using the CTRL + H function I get the find and replace feature popping up. How do I get it to sort properly using CTRL + H? Based on the same formula my other columns d-g sort properly. Any advice is appreciated. Sub Macro5() ' ' Macro1 Macro ' Macro created 06/09/2006 ' Keyboard Shortcut: Ctrl+h ' Range("C13:H58").Select Range("H13").Activate Selection.Sort Key1:=Range("H13"), Order1:=xlDescending, Header:=xlNo, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Range("G7").Select End Sub |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sort in excel (office xp)
Francine
As you have seen, lots of those CTRL+A,B,C combinations are reserved for shortcuts. Why don't you set them all (or just this one?) to work with CTRL+SHIFT+A,B,C etc? Those aren't reserved at least until you get to O (I tried them). You must have had the same problem with column F. -- Allllen "Francine" wrote: I am trying to get column H to sort as the others are doing using a macro (see below). Using the CTRL + H function I get the find and replace feature popping up. How do I get it to sort properly using CTRL + H? Based on the same formula my other columns d-g sort properly. Any advice is appreciated. Sub Macro5() ' ' Macro1 Macro ' Macro created 06/09/2006 ' Keyboard Shortcut: Ctrl+h ' Range("C13:H58").Select Range("H13").Activate Selection.Sort Key1:=Range("H13"), Order1:=xlDescending, Header:=xlNo, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Range("G7").Select End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Office XP SP3 interfering w/ Excel | Excel Discussion (Misc queries) | |||
Excel needs to let the user set the sort default to "NO HEADER ROW | Excel Worksheet Functions | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
I want to sort selected cells in Excel, not entire rows. | Excel Discussion (Misc queries) | |||
Installed Word XP only, then applied Office SP3, then Excel - need 2 re-update? | Excel Discussion (Misc queries) |