Sub MAXFIRST()
Dim adresse$, celluletrouvée As Range
With Sheets(1) 'sheets a adapter
adresse = .Range("A1", Cells(Rows.Count, "A").End(xlUp)).Address(0, 0) 'lettre de colonne a adapter
Set celluletrouvée = .Range("A" & Evaluate("= MATCH(MAX(" & adresse & ")," & adresse & ",0)"))
End With
MsgBox celluletrouvée.Address
End Sub