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

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 <(E-Mail Removed)>
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.