View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Hutchins Tom Hutchins is offline
external usenet poster
 
Posts: 1,069
Default 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