How do I sort a table w/ merged cells
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
|