| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
separate each sort order ?
Hi
How do I separate each sort order and move to next blank column with heading and also how I automatically change range of data. Sub changeorder() Range("A4").Select Range("A1:A110").Sort Key1:=Range("A2"), Order1:=xlAscending, Header:= _ xlYes, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Columns(1).Copy Cells(1, 256).End(xlToLeft)(1, 2).EntireColumn End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can three separate sections of rows be sorted in the same order? | Excel Worksheet Functions | |||
| How to insert macro results on a separate spreadsheet in row order | Excel Discussion (Misc queries) | |||
| Retaining Sort order in the Sort Dialog box | Excel Discussion (Misc queries) | |||
| Sort sheet based on particuilar sort order | Excel Worksheet Functions | |||
| Pls. reply Sort Data and copy to next coulmn when sort order chang | Excel Programming | |||
Threaded Mode
