Private Sub CommandButton1_Click()
Dim lig As Long, mga As Variant, s
lig = 10
With Feuil1
Do Until .Cells(lig, 1) = ""
If .Cells(lig, 1).MergeCells Then
Set mga = .Cells(lig, 1).MergeArea
s = mga.Address
lig = Mid$(s, InStrRev(s, "$") + 1)
.Cells(lig, 1) = "x"
End If
lig = lig + 1
If lig = 20 Then lig = lig + 4
If lig = 31 Then Unload Me
Loop
.Cells(lig, 1) = "x"
End With
End Sub