Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sort button
I have a date range A11:H500 (column B contains dates). I want to use a Form
Button that will sort the data in Decending date order. Can someone help me with the macro. Using Excel 2003. Much appreciated |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sort button
Using the macro recorder I get this. HTH Otto
Sub SortIt Range("A11:H500.Sort Key1:=Range("B11"), Order1:=xlDescending, Header:=xlNo, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom End Sub "JeffK" wrote in message ... I have a date range A11:H500 (column B contains dates). I want to use a Form Button that will sort the data in Decending date order. Can someone help me with the macro. Using Excel 2003. Much appreciated |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
sort button
Oops. That should be: HTH Otto
Sub SortIt Range("A11:H500").Sort Key1:=Range("B11"), Order1:=xlDescending, Header:=xlNo, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom End Sub "Otto Moehrbach" wrote in message ... Using the macro recorder I get this. HTH Otto Sub SortIt Range("A11:H500.Sort Key1:=Range("B11"), Order1:=xlDescending, Header:=xlNo, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom End Sub "JeffK" wrote in message ... I have a date range A11:H500 (column B contains dates). I want to use a Form Button that will sort the data in Decending date order. Can someone help me with the macro. Using Excel 2003. Much appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort Button | Excel Discussion (Misc queries) | |||
Automated sort button | Excel Discussion (Misc queries) | |||
Create a sort button? | Excel Discussion (Misc queries) | |||
Making a button to sort | Excel Worksheet Functions | |||
Add Sort button | Excel Programming |