|
|
|
Author |
Message |
Debora
|
Posted: Mon Feb 16 07:27:12 CST 2004 |
Top |
Excel Programming >> Sort data failure
I am trying to sort data in two columns that in effect are
merged in different ways.
Explanation : H7 to J7 merged and K7 to L7 merged
H8 to L8 merged and K8 to L8 merged
and so on.
here is my routine;
Sub Sortdata2()
Range("H7:L13").Select
Selection.Sort Key1:=Range("H7:J7"), Order1:=xlAscending,
Key2:=Range("K7:L7") _
, Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1,
MatchCase:= _
False, Orientation:=xlTopToBottom
End Sub
However I get a run error 1004 - where am I going wrong ?
Thanks
Robert Pollock
Excel288
|
|
|
|
|
Tom
|
Posted: Mon Feb 16 07:27:12 CST 2004 |
Top |
Excel Programming >> Sort data failure
Key1 and key2 are not going to accept a multicell range. Can you sort this
range manually - My impression is that sort doesn't work well with merged
cells.
--
Regards,
Tom Ogilvy
> I am trying to sort data in two columns that in effect are
> merged in different ways.
>
> Explanation : H7 to J7 merged and K7 to L7 merged
> H8 to L8 merged and K8 to L8 merged
> and so on.
>
> here is my routine;
>
> Sub Sortdata2()
> Range("H7:L13").Select
> Selection.Sort Key1:=Range("H7:J7"), Order1:=xlAscending,
> Key2:=Range("K7:L7") _
> , Order2:=xlAscending, Header:=xlGuess, OrderCustom:=1,
> MatchCase:= _
> False, Orientation:=xlTopToBottom
> End Sub
>
> However I get a run error 1004 - where am I going wrong ?
>
> Thanks
> Robert Pollock
>
|
|
|
|
|
|
|