Thread: Sorting problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Francine Francine is offline
external usenet poster
 
Posts: 2
Default Sorting problem

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