Testing for merged cells

[mosiki]

Is there a VBA property that can be used to test if a range is merged

eg.

if worksheet1.cells("A:D").MergedCells = true then.............


Thanks

Mosiki

 

[Andrew Poulsom]

The MergeArea property returns a Range object that represents the merged range containing the specified cell. If the specified cell isn’t in a merged range, this property returns the specified cell. See the example in VBA Help.

 

[machopicho]

Try:

Sub Test()
If Range("A1:B1").MergeCells = True Then
MsgBox ("ok")
Else: MsgBox ("no")
End If
End Sub