Tom, Good idea except my boss won't be too happy when I push all his summary
stats way to the right on the worksheet w/ the table! The rows above the
table contain a bunch of columns of summary data and the table spans these
rows. I had to merge all these cells in table rows in order to compensate
and do the table like my boss wants. There is a similar problem w/ data
below the table. I can't move the table to the right either since it has to
print in line w/ all the other data.

Sooo. How do I sort a table containing merged cells?

"Tom Hutchins" wrote:

Unmerge the cells in columns F-M, and set the column width of F to 72. Then
sort normally. All the data is in column F anyway; columns G-M are empty.

Hope this helps,

Hutch

"John" wrote:

I have a 12 column table (cols B -M). Each row is formated the same and the
last 8 columns of each row (cols F thru M, all having a width of 9) are
merged into single cells in the row.

What code could I use to place the rows in alphabetic order, first by col C
and then by col B?

Whenever I try to sort this table manually using the Sort option on the Data
Ribbon, I get the error: This operation requires the merged cells to be
identically sized.

I appreciate your help, -John