Hi there,

In a table we have 5 rows and 5 columns and in 4th row cell 1 and 2 are merged so the row 4 is now containing 4 cells.

Now

VB:

Selection.Tables(1).Rows(1).Cells.Count

Formatting tags added by mark007

gives 5

VB:

Selection.Tables(1).Rows(2).Cells.Count

Formatting tags added by mark007

gives 5

VB:

Selection.Tables(1).Rows(3).Cells.Count

Formatting tags added by mark007

gives 5

VB:

Selection.Tables(1).Rows(4).Cells.Count

Formatting tags added by mark007

**gives 4**

VB:

Selection.Tables(1).Rows(5).Cells.Count

Formatting tags added by mark007

gives 5

By looking at the table I can say that first two cells are merged in 4 row but using VBA can I locate a merged cell and its length?

Thanks in advance.

Chandan