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!

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!