Function MaxLignes() As Long
Dim sh As Worksheet
Dim nbLignes As Long
For Each sh In Worksheets(Array("Feuil1", "Feuil2", "Feuil3"))
nbLignes = sh.Cells(Rows.Count, 1).End(xlUp).Row - 1
If MaxLignes < nbLignes Then MaxLignes = nbLignes
Next
End Function
Function MaxLignes2() As Long
MaxLignes2 = Application.Max(Sheets("Feuil1").Cells(Rows.Count, 1).End(xlUp).Row - 1, _
Sheets("Feuil2").Cells(Rows.Count, 1).End(xlUp).Row - 1, _
Sheets("Feuil3").Cells(Rows.Count, 1).End(xlUp).Row - 1)
End Function