search for merged cells

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!
 
J

Jezebel

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.
 
G

Guest

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.






.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top