search for merged cells

  • Thread starter Thread starter Carol
  • Start date Start date
C

Carol

does anyone know how i can search for merged fields? I
get an error message that word can't sort my table
because somewhere in it i have a merged field. or else,
what's the best way to find a merged field in a HUGE
table? thanks!
 
Method 1: Split the table in the middle. Try sorting each half: the half it
fails on has the merged cell. Repeat until you've got a table small enough
to check visually.

Method 2: Adjust the column widths. Rows with merged cells may go obviously
haywire.

Method 3: Use VBA. Iterate the cells checking the RowIndex and ColumnIndex
properties.
 
THANK YOU very much - carol
-----Original Message-----
Method 1: Split the table in the middle. Try sorting each half: the half it
fails on has the merged cell. Repeat until you've got a table small enough
to check visually.

Method 2: Adjust the column widths. Rows with merged cells may go obviously
haywire.

Method 3: Use VBA. Iterate the cells checking the RowIndex and ColumnIndex
properties.






.
Click to expand...
 
Back
Top