Macro to sort two areas on a sheet at the same time.

[tonywatsonhelp]

Hello Everyone,

Not sure if this is posible, but i have a sheet with dta and some of it needs sorting and some doesn't.

Is it posible to have a macro sort active sheet Columns C:H & P:W by column C?

please help if you can
thanks

Tony

 

[veyselemre]

If the X column is empty, you can do as follows.

Sub test()
    Columns("C:C").Copy Range("X1")
    Columns("C:I").Sort Range("C1")
    Columns("P:X").Sort Range("X1")
    Columns("X").Delete
End Sub

 

[tonywatsonhelp]

Got you, thanks