Sub test_ok()
Dim F As Worksheet, R As Range: Set F = ActiveSheet
Set R = F.Range(F.[A7], F.Cells(F.Rows.Count, "A").End(xlUp))
With Application
.ScreenUpdating = False
F.[A3].Value = Format(Date, """Nombre de fichiers au "" dd/mm/yyyy") & " : " & .WorksheetFunction.CountA(R)
End With
End Sub