| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Sort NOT working...
I've used this code for awhile, & it HAD worked.
But NOT now. Range("DTop").Select Selection.Sort Key1:=Range("AJ65"), Order1:=xlDescending, Header:=xlGuess _ , OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Is there another way to ensure a Sort?? TIA - Bob |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Sort NOT working...
Doing a little reading in Old threads...the solution...
the recorded macro had Header:=xlGuess which needs to be replaced w/ ....Header:=xlNo Bob "Bob Barnes" wrote: I've used this code for awhile, & it HAD worked. But NOT now. Range("DTop").Select Selection.Sort Key1:=Range("AJ65"), Order1:=xlDescending, Header:=xlGuess _ , OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Is there another way to ensure a Sort?? TIA - Bob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort corrupts mass data intermittently? | Excel Discussion (Misc queries) | |||
| Excel 2003 Data Sort & Subtotaling not working properly | Excel Discussion (Misc queries) | |||
| macro to sort data in worksheet by specific date | Excel Discussion (Misc queries) | |||
| Data Connection wizard quits working | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Hybrid Mode
