How to tell : how many rows a merged Column run over ..

[smallville]

for example ,if column A in row 1 ,2 ,3 was merged into one row .

There is only A1 left ,no A2 or A3 anymore.

But how to know A1 was originally merged from row 1,2,3.


THANKS!

 

[Rob van Gelder]

The MergeCells property returns True if the range contains merged cells.

Sub testit()
MsgBox Range("A1").MergeCells
MsgBox Range("A1").MergeArea.Address
End Sub

Rob