EXCEL SORT VBA - Sort outside

Question

This is working:

Columns("A:L").Sort Key1:=Range("L1"), Order1:=xlAscending, Header:=xlGuess, _
        OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

I need to:

Columns("A:L").Sort ***Key1:=Range("W1")***, Order1:=xlAscending, Header:=xlGuess, _
        OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

Is normal to generate error! I don't want to Columns("A:W").Sort!

I need to sort just A:L by values on W1 using VBA.

KekuSemau · Accepted Answer · 2013-05-09 12:35:11Z

2

Well, logically it is improbable that sorting A:L by Column W makes sense, without including column W in the sorting. If you do so, you can repeat the same sorting process and A:L are shuffled again into a different order!
So, the only seemingly reasonable thing is to sort A:L,W:W, but Excel cannot do this (only one contiguous area, in the versions I know). Only solution: copy W:W next to L and sort A:M.

answered May 9, 2013 at 12:35

KekuSemau

6,8424 gold badges27 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

KekuSemau Over a year ago

Hi, great that it helps. So, then please mark (accept) the answer so others can see that the issue has been solved (and I get some points, too :) ).

Collectives™ on Stack Overflow

EXCEL SORT VBA - Sort outside

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related