complex Cell

Al · Sep 9, 2003

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 · Sep 10, 2003

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

BR, Al

Dave Peterson · Sep 11, 2003

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

complex Cell

Al

Al

Dave Peterson