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

[vba]Selection.Tables(1).Rows(1).Cells.Count [/vba]gives 5

[vba]Selection.Tables(1).Rows(2).Cells.Count [/vba]gives 5

[vba]Selection.Tables(1).Rows(3).Cells.Count [/vba]gives 5

[vba]Selection.Tables(1).Rows(4).Cells.Count [/vba]gives 4

[vba]Selection.Tables(1).Rows(5).Cells.Count [/vba]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