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