Je suppose qu'au départ les lignes 15, 26, 37, etc... sont vides, alors utilisez :
Code:
Sub EnTetes()
Dim P As Range, Q As Range, col As Range
Set P = Range("A4:C" & Rows.Count) 'à adapter
On Error Resume Next
Set Q = P.Columns(1).SpecialCells(xlCellTypeBlanks).EntireRow
For Each col In P.Columns
Intersect(col, Q) = col.Cells(1)
Next
End Sub
Merci pour le Like MADA mais bof il y a vraiment plus simple :
Code:
Sub EnTetes()
On Error Resume Next
With Range("A4:C" & Rows.Count) 'à adapter
.Rows(1).Copy .Columns(1).SpecialCells(xlCellTypeBlanks)
End With
End Sub