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

  • Thread starter Thread starter smallville
  • Start date Start date
S

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!
 
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
 
Back
Top