View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Francine
 
Posts: n/a
Default 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