Sub SupprimeErreurs()
'Feuil4 et Feuil8 sont les CodeNames des feuilles
Dim dest As Range, source As Range
Set dest = Feuil4.Cells(82, "B") 'à adapter
With Feuil8 'feuille source, à adapter
Set source = .Cells(152, "M") 'à adapter
Set source = .Range(source, .Cells.SpecialCells(xlCellTypeLastCell))
End With
Application.ScreenUpdating = False
dest.Resize(Rows.Count - dest.Row + 1).EntireRow.Clear 'RAZ
With dest.Resize(source.Rows.Count, source.Columns.Count)
source.Copy .Cells 'pour copier les formats
.Value = source.Value 'copie les valeurs
On Error Resume Next 'si aucune valeur d'erreur
.SpecialCells(xlCellTypeConstants, xlErrors).EntireRow.Delete
End With
dest.Parent.Columns.AutoFit 'ajustement largeur
End Sub