Sub Plages_fusionnées()
Dim T(), d As Object, i As Long
For Each c In ActiveSheet.Range("A1:J20")
If c.MergeCells Then
ReDim Preserve T(0 To i)
T(i) = c.MergeArea.Address
i = i + 1
End If
Next c
Set d = CreateObject("scripting.dictionary")
For i = 1 To UBound(T)
d(T(i)) = d(T(i))
Next i
MsgBox "les plages fusionnées sont " & Join(d.keys)
End Sub