Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Column matching - sorting. Fairly hard problem, I think. A S-D Excel Discussion (Misc queries) 13 April 7th 06 01:52 PM
Problem sorting cells containing hyperlinks cottonchipper Excel Worksheet Functions 1 November 5th 05 03:08 PM
Date sorting problem Ardell Excel Discussion (Misc queries) 1 November 4th 05 05:46 PM
An instant sorting problem Chris Excel Worksheet Functions 1 November 4th 04 07:31 PM
Sorting problem Chris Excel Worksheet Functions 1 November 3rd 04 11:27 PM


All times are GMT +1. The time now is 01:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"