| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting automatically by columns | Excel Discussion (Misc queries) | |||
| Sorting by Two Columns | Excel Worksheet Functions | |||
| How do I link two columns for sorting? | Excel Discussion (Misc queries) | |||
| Macro sorting by 4 columns | Excel Discussion (Misc queries) | |||
| sorting data across multiple columns | Excel Discussion (Misc queries) | |||
Linear Mode
