Private Sub CommandButton1_Click()
ligne = ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell).Row
For i = 2 To ligne
For j = 2 To 8
If Cells(i, j) = "" Then Cells(i, j) = "NA"
If Cells(i, j) = 0 Then Cells(i, j) = "Date non valide"
Next j
Next i
End Sub