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