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


"smallville" wrote in message
...
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!