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

You do not say which version of Excel you're using. In my version
(2002), assigning a shortcut key to a macro overrides the built-in
function of that shortcut key. Therefore, if you go to menu Tools,
then Macro, then Macros and select the macro from the list, then click
Options and set the shortcut key to h, Ctrl-h will run the macro and
not find/replace. Are you sure you're putting in a small h and not a
capital H?
James

Francine wrote:
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

Zone, thanks. I did not specify which version (office xp) but you
helped with my issue I didn't know about the options to set the
shortcut to ctrl +h. You saved me alot of headache, and now it works.

Thanks again.



Zone wrote:
You do not say which version of Excel you're using. In my version
(2002), assigning a shortcut key to a macro overrides the built-in
function of that shortcut key. Therefore, if you go to menu Tools,
then Macro, then Macros and select the macro from the list, then click
Options and set the shortcut key to h, Ctrl-h will run the macro and
not find/replace. Are you sure you're putting in a small h and not a
capital H?
James

Francine wrote:
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