Option Explicit
Declare Function GetTickCount& Lib "kernel32" ()
Sub TpsCalc()
Dim ret1 As Double, ret2 As Double
Application.Calculation = xlCalculationManual
' ----Range("Laplage") contient X fois strictement la meme formule
Application.ScreenUpdating = False
ret1 = GetTickCount&
ActiveSheet.Range("Laplage").Calculate
ret2 = GetTickCount&
[A1] = ret1
[B1] = ret2
Application.ScreenUpdating = True
MsgBox "par cellule " & Chr(10) & Format((ret2 - ret1) / Range("Laplage").Cells.Count, "0.000000") & " millisec", , Range("Laplage").Cells.Count & "cellules"
End Sub