Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Column Order (Not Rows) with Sort Function
Hello all,
I thought this would be easy - but I'm obviously mistaken. I want to be able to order my columns in ascending or descending order (left to right). For examply A1 = Apple, B1 = Peach, C1 = Banana. I want to move Banana (and all of its rows) between the Apple column and Peach column. Could someone give me a chunk of sample code using sort please. I've tried most everything but keep getting object errors as soon as I throw in XLSortOrientation. Any insight would be greatly appreciated! Thanks! Trip |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Column Order (Not Rows) with Sort Function
Hi Trip.
Try: Sub SortLrftToRight() Dim rng As Range Set rng = Range("A1:G10") '<==========AMEND!! rng.Sort _ Key1:=rng(1), _ Order1:=xlAscending, _ Header:=xlGuess, _ OrderCustom:=1, _ MatchCase:=False, _ Orientation:=xlLeftToRight End Sub --- Regards, Norman "Trip Ives" wrote in message om... Hello all, I thought this would be easy - but I'm obviously mistaken. I want to be able to order my columns in ascending or descending order (left to right). For examply A1 = Apple, B1 = Peach, C1 = Banana. I want to move Banana (and all of its rows) between the Apple column and Peach column. Could someone give me a chunk of sample code using sort please. I've tried most everything but keep getting object errors as soon as I throw in XLSortOrientation. Any insight would be greatly appreciated! Thanks! Trip |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Column Order (Not Rows) with Sort Function
Just to add:
Easiest way to get the code and argument values is to turn on the macro recorder while you do it manually. -- Regards, Tom Ogilvy "Trip Ives" wrote in message om... Hello all, I thought this would be easy - but I'm obviously mistaken. I want to be able to order my columns in ascending or descending order (left to right). For examply A1 = Apple, B1 = Peach, C1 = Banana. I want to move Banana (and all of its rows) between the Apple column and Peach column. Could someone give me a chunk of sample code using sort please. I've tried most everything but keep getting object errors as soon as I throw in XLSortOrientation. Any insight would be greatly appreciated! Thanks! Trip |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
numbering rows in order 1 through whatever, then changing. | Excel Discussion (Misc queries) | |||
How do I sort or filter rows without column A data changing? | Excel Discussion (Misc queries) | |||
sorting rows without changing order of my values! | Excel Discussion (Misc queries) | |||
sort rows in alphabetical order and move the corresponding data | Excel Worksheet Functions | |||
Sort Rows in order and re-align cross table | Excel Programming |