Sub Transfert()
Feuil2.Rows("3:" & Rows.Count).Delete 'RAZ
On Error Resume Next 'si aucune SpecialCell
With Feuil1.[A4].CurrentRegion
Intersect(.Columns(16).SpecialCells(xlCellTypeBlanks).EntireRow, .Columns(2).Resize(, 10)).Copy Feuil2.[A3]
End With
With Intersect(Feuil2.UsedRange, Feuil2.Range("A3:J" & Rows.Count)).Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.Weight = xlMedium
End With
Feuil2.Activate 'facultatif
End Sub