Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |