red bitroot
05-20-2005, 04:43 AM
I created a sort instruction by using a macro in Excel.
It is as follows :
Selection.Sort Key1:=Range("A217"), Order1:=xlAscending, Key2:=Range( _
"B217"), Order2:=xlAscending, Key3:=Range("C217"), Order3:=xlDescending, _
Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:= _
xlTopToBottom, DataOption1:=xlSortNormal, DataOption2:=xlSortNormal, _
DataOption3:=xlSortNormal
I would create this instruction programmatically with VBA in order to use following instruction
Selection.Sort SortProjectParameters
where SortProjectParameters is a string that I've fullfilled according to the sort parameters I want to use.
When the sort is launch, I receive the message :
Execution error 13
Incompatibilit? de type (sorry, but I'm using the french version of Excel).
Can somebody help me ?
Thanks in advance.
Red bitroot :hi:
It is as follows :
Selection.Sort Key1:=Range("A217"), Order1:=xlAscending, Key2:=Range( _
"B217"), Order2:=xlAscending, Key3:=Range("C217"), Order3:=xlDescending, _
Header:=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:= _
xlTopToBottom, DataOption1:=xlSortNormal, DataOption2:=xlSortNormal, _
DataOption3:=xlSortNormal
I would create this instruction programmatically with VBA in order to use following instruction
Selection.Sort SortProjectParameters
where SortProjectParameters is a string that I've fullfilled according to the sort parameters I want to use.
When the sort is launch, I receive the message :
Execution error 13
Incompatibilit? de type (sorry, but I'm using the french version of Excel).
Can somebody help me ?
Thanks in advance.
Red bitroot :hi: