Bonjour,
Une proposition.
Cdlt.
Public Sub VERI()
Dim rng As Range
Dim lastRow As Long
Dim dt As Double, dt2 As Double, n As Double
With ActiveSheet
dt = .Cells(2, 6).Value2: dt2 = .Cells(3, 6).Value2
lastRow = .Cells(.Rows.Count, 2).End(xlUp).Row
Set rng = .Cells(2, 2).Resize(lastRow - 1)
n = WorksheetFunction.CountIfs(rng, ">=" & dt, rng, "<=" & dt2)
If n > 0 Then
.Cells(4, 6).Value = n
Else
.Cells(4, 6).Value = vbNullString
MsgBox "Rien"
End If
End With
End Sub