Dim a As Integer Dim b As Integer Dim c As Integer Dim i As Integer Dim j As Integer c = 3 For i = 3 To Sheets("Modules Transversaux").Range("D65536").End(xlUp).Row j = i a = Sheets("Modules Transversaux").Range("B" & j).MergeArea.Rows.count If a >= 2 Then For b = 1 To a Sheets("Modules Transversaux").Range("G" & c).Value = "Date" & b c = c + 1 i = j + b Next b ElseIf a = 1 Then Sheets("Modules Transversaux").Range("G" & j).Value = "" End If Next i
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question