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

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!

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

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!