Option Explicit
Dim AdresseTrouvee As String
Public lLig As String
Public cCol As String
Sub SelectAnnée()
Dim Annee As Range, PlageDeRecherche As Range
Dim Valeur_Cherchee As String
Dim NumLig As Long
Dim c As Range
Valeur_Cherchee = Sheets("Feuil2").Range("A" & 1)
Set PlageDeRecherche = Sheets("Feuil1").Rows(1)
Set Annee = PlageDeRecherche.Cells.Find(what:=Valeur_Cherchee, LookAt:=xlWhole)
If Annee Is Nothing Then
AdresseTrouvee = "$0$0"
Else
AdresseTrouvee = Annee.Address(ColumnAbsolute:=True, RowAbsolute:=True)
End If
lLig = Split(AdresseTrouvee, "$")(1)
cCol = Split(AdresseTrouvee, "$")(2)
End Sub