sort columns with multiple selection

Hi,

Attached is the example sheet

I would like to sort A,C,E columns based on A column data either ascending or descending and have to sort B,D,F columns based on B column data.

I am using the followin code here:

Please Login or Register  to view this content.

But facing problem as I have described in the above code. Can any body help how sort columns with multiple selection? Any help will be greatly appreciated.

Thanks

You can't sort nonadjacent columns, so just put the columns to sort together, sort, then put them back.

Please Login or Register  to view this content.