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
Bookmarks