Sorting Columns

[Bernie]

I need to sort columns, except for the first two, and the last. Just
the ones in the middle. A column will be added in the middle when
another macro is run to add.

Thanks,
Bern

 

[Roger Govier]

Hi

Mark your range of columns, Data>Sort>Options>sort Left to Right

 

[Bernie]

Thank you Roger, but I wasn't clear enough. I need it in macro form.

Thanks,
Bern

 

[Dave Peterson]

Try recording a macro when you do it manually???????

 

[Gord Dibben]

Bernie

The macro recorder is a very handy tool.


Gord Dibben MS Excel MVP

 

[Bernie]

I did do it manually but i don't know how to write the macro to use the
range of column d through column X becuause I add columns all the time.

bern