Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
problem excel 2000
I use the following line in excel 2003:
Range(Cells(1, ccol), Cells(I - 1, ccol + 1)).Select Selection.Sort Key1:=Range(Cells(2, ccol).Address), Order1:=xlAscending, Header:=xlGuess, OrderCustom:=1, _ MatchCase:=False, Orientation:=xlTopToBottom, DataOption1:=xlSortNormal Works fine. When i use this macro in excel 2000 it does not work. What is going wrong? Greetings Hans |
#2
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) |