complex Cell

[Al]

I had a cell, that consist of 2 cells (1 row, 2 columns).
How can I recognize from range object, that I recived,
that the cell is complex?

 

[Al]

Thanks,
but how can I understand with wich cell my cell is merged?

BR, Al

 

[Dave Peterson]

One way:

Option Explicit
Sub testme02()

Dim myCell As Range
Set myCell = ActiveCell

If myCell.MergeCells = True Then
MsgBox Prompt:="found at: " _
& myCell.Address(0, 0) & " Of " _
& myCell.MergeArea.Address(0, 0)
End If

End Sub