| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alphabetical sort but includes the expanded section when it rearra
How do you get a database to alphabetically sort (VBA) by say the first row
(last names) but then when it sorts and uses the expanded area. So that the rest of your data rearranges also. -- CG |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Alphabetical sort but includes the expanded section when it rearra
Select the entire region that is to be sorted (all columns, not just
the last name column) and then sort, specifying the last name column as the key. Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sun, 23 Nov 2008 08:20:03 -0800, CG wrote: How do you get a database to alphabetically sort (VBA) by say the first row (last names) but then when it sorts and uses the expanded area. So that the rest of your data rearranges also. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alphabetical sort in a macro | Excel Programming | |||
| how do I sort an excel list that includes pictures (name-picture) | Excel Discussion (Misc queries) | |||
| alphabetical sort | Excel Worksheet Functions | |||
| Sort - Not Alphabetical | Excel Discussion (Misc queries) | |||
| sort by section number | Excel Discussion (Misc queries) | |||
Linear Mode
