salut
le code devient comme ça?merci
Sub Archiver()
Dim arch(), mc, col, n%, i%, j%, k%, celC As Range
Set celC = Worksheets("ARCHIVE RDA").Cells(Rows.Count, 1).End(xlUp)(2)
With ActiveSheet
n = .Cells(.Rows.Count, 2).End(xlUp).Row
If n < 8 Then Exit Sub
mc = Split("K6 P6 Q6 N8 R6"): col = Array(2, 3, 9)
ReDim arch(n - 8, 7)
For i = 8 To n
For j = 0 To 4
arch(k, j) = .Range(mc(j)).Value2
Next j
For j = 0 To 2
arch(k, j + 5) = .Cells(i, col(j))
Next j
k = k + 1
Next i
celC.Resize(k, 8).Value = arch
celC.Worksheet.Activate 'pour voir résultat
'ci-dessous effacement RDA (à supprimer si on n'efface pas)
'avant effacement
n = .Range("K6") + 1
.Range("B8").Resize(k, 8).ClearContents
For i = 0 To 4
.Range(mc(i)).MergeArea.ClearContents
Next i
'après effacement
.Range("K6") = n
End With
End Sub