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

Gord Dibben wrote:
Bernie

The macro recorder is a very handy tool.


Gord Dibben MS Excel MVP

On 29 Dec 2006 09:46:08 -0800, "Bernie" wrote:

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

Thanks,
Bern

Roger Govier wrote:
Hi

Mark your range of columns, DataSortOptionssort Left to Right

--
Regards

Roger Govier


"Bernie" wrote in message
ups.com...
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