Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to get column H ansd I 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. I whish not to use the CTRL+SHIFT+H etc. 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 | |||
Column matching - sorting. Fairly hard problem, I think. | Excel Discussion (Misc queries) | |||
Problem sorting cells containing hyperlinks | Excel Worksheet Functions | |||
Date sorting problem | Excel Discussion (Misc queries) | |||
An instant sorting problem | Excel Worksheet Functions | |||
Sorting problem | Excel Worksheet Functions |