Dim myRange As Range Set myRange = Worksheets("Feuil1").Range("B5:B8") MsgBox WorksheetFunction.Average(myRange)
Dim monTableau(0 To 3) As Integer monTableau(0) = 1 monTableau(1) = 2 monTableau(2) = 12 monTableau(3) = 3 MsgBox WorksheetFunction.Average(monTableau)