[COLOR="DarkSlateGray"][B]Private Sub Worksheet_Activate()
Dim x&, i&, Tabl1, Tabl2, Tabl3
Application.ScreenUpdating = False
x = 9
Tabl1 = Worksheets("Feuil1").Range("A2:A" & x).Value
Tabl2 = Worksheets("Feuil2").Range("A2:A" & x).Value
ReDim Tabl3([B][COLOR="Red"]1 To x - 1[/COLOR][/B], [B][COLOR="Red"]1 To 1[/COLOR][/B])
For i = 1 To x - 1
If Tabl2(i, 1) <> 0 And Not IsEmpty(Tabl1(i, 1)) Then Tabl3(i, 1) = Tabl1(i, 1) / Tabl2(i, 1)
Next i
Worksheets("Feuil1").Range("B2:B" & x).Value = Tabl3
Application.ScreenUpdating = True
End Sub[/B][/COLOR]