Sub valnum()
Dim lastRow As Long
'
' Ligne de la dernière cellule
With Range("A4").CurrentRegion
lastRow = .Cells(.Cells.Count).Row
End With
'
' SpecialCells lèvera une erreur si aucune cellule ne correspond
On Error Resume Next
Intersect(Columns("E:N"), Range("O5:O" & lastRow).SpecialCells(xlCellTypeConstants, 23)).ClearContents
Intersect(Columns("P:V"), Range("W5:W" & lastRow).SpecialCells(xlCellTypeConstants, 23)).ClearContents
On Error GoTo 0
End Sub