Option Explicit
Sub valid_analyse()
Application.ScreenUpdating = False
Dim i As Integer, n As Long, j As Integer 'déclaration des variables
If CDate(Range("D_BASE")) <> CDate(Range("D_MODIF")) Then 'analyse date
MsgBox ("Date Base différente de date modif")
Exit Sub
End If
For n = 1 To [HISTO_T_GB].Rows.Count 'analyse si sauvegarde déjà effectuée
If [HISTO_T_GB].Item(n, 1) = Sheets("ANALYSE").Range("E4").Value Then
MsgBox ("Sauvegarde déjà effectuée")
Exit Sub
End If
Next
Range("T_GB_2").ListObject.DataBodyRange.Copy Range("HISTO_T_GB").ListObject.ListRows.Add.Range
End Sub