Re : Maximum spécial
1 secondes pour 50000 lignes, c'est pas mieux ?
Sub Test()
Dim derlig As Long, NoLig As Long, NoLig2 As Long, valeur As Long, valmax As Long
derlig = Split(Worksheets("feuil1").UsedRange.Address, "$")(4)
Do
NoLig = NoLig + 1
valeur =...