Sub RechercheDateLigne()
Dim lig&, x$, i As Variant
lig = 9 'ligne de la recherche, à adapter
1 x = InputBox("Date recherchée :", "Recherche", x)
If x = "" Then Exit Sub
If Not IsDate(x) Then GoTo 1
i = Application.Match(CDbl(CDate(x)), Rows(lig), 0)
If IsError(i) Then GoTo 1
Cells(lig, i).Select
End Sub
Sub RechercheDateFeuille()
Dim x$, i As Double, lig&, j As Variant
1 x = InputBox("Date recherchée :", "Recherche", x)
If x = "" Then Exit Sub
If Not IsDate(x) Then GoTo 1
i = CDbl(CDate(x))
With ActiveSheet.UsedRange
For lig = 1 To .Rows.Count
j = Application.Match(i, .Rows(lig), 0)
If IsNumeric(j) Then .Cells(lig, j).Select: Exit For
Next
If IsError(j) Then GoTo 1
End With
End Sub