Sorting Columns
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 |
Sorting Columns
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 |
Sorting Columns
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 |
Sorting Columns
Try recording a macro when you do it manually???????
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 -- Dave Peterson |
Sorting Columns
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 |
Sorting Columns
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 |
All times are GMT +1. The time now is 09:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com