| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem excel 2000
Remove the ", DataOption1:=xlSortNormal" from the fine part of your macro
See whether it works So, the code becomes Range(Cells(1, ccol), Cells(I - 1, ccol + 1)).Selec Selection.Sort Key1:=Range(Cells(2, ccol).Address), Order1:=xlAscending, Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBotto Regards Edwin Ta http://www.vonixx.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2000 Problem | Excel Discussion (Misc queries) | |||
| PROBLEM:How to squeeze 2 Page sized Chart in Excel 2000 & embed in Word 2000 and print from Word to fit one page ??? | Excel Discussion (Misc queries) | |||
| PROBLEM:How to squeeze 2 Page sized Chart in Excel 2000 & embed in Word 2000 and print from Word to fit one page ??? | New Users to Excel | |||
| excel 2000 problem | Excel Worksheet Functions | |||
| Problem with Excel 2000 | Excel Discussion (Misc queries) | |||
Hybrid Mode
