I have a Worksheet to sort, that has similar data to the table below:

A B C
1 Category Number Level
2 Black 05 A
3 Black 14 A
4 Black 14 C
5 Black 16 B
6 Total 49
7 White 03 B
8 White 03 C
9 Total 6
10 Red 04 A
11 Red 04 B
12 Red 04 C
13 Red 16 B
14 Total 28


There are three sort areas in this example: Black, White & Red. I want
to sort each area using columns B as Key1 and C as Key2. Column A would
be the same value with no need to sort. The example is already sorted
correctly.

If someone just pasted this into a worksheet, but with each area out of
sequence, I’m looking for a vba script which would recognize each area,
determine the number of rows, set this as the sort area and using B & C
as Keys, sort alphabetically the area.


--
rlutes
------------------------------------------------------------------------
rlutes's Profile: http://www.excelforum.com/member.php...o&userid=24038
View this thread: http://www.excelforum.com/showthread...hreadid=379549