Sub Nettoyage()
On Error Resume Next 'si la feuille est vide
With ActiveSheet
.Rows(.[A1].Find("*", , xlFormulas, , xlByRows, xlPrevious).Row + 1 & ":" & .Rows.Count).Delete
.Range(.Columns(.[A1].Find("*", , , , xlByColumns, xlPrevious).Column + 1), .Columns(.Columns.Count)).Delete
With .UsedRange: End With 'actualise les barres de défilement
End With
End Sub