1 2 3 4 5 6 7 8 9 10 11
| Sub tesBis()
Dim Cpt As Long, i As Long, X As Double, Y As Double
Cpt = 2
For i = 3 To Cells(Rows.Count, 1).End(xlUp).Row
'X = Cells(i, 1).Value & " - " & Cells(Cpt, 1).Value: Y = Cells(i, 2).Value & " - " & Cells(Cpt, 2).Value
X = Cells(i, 1).Value - Cells(Cpt, 1).Value: Y = Cells(i, 2).Value - Cells(Cpt, 2).Value
Cells(Cells(Rows.Count, 4).End(xlUp)(2).Row, 4).Value = ((X ^ 2) + (Y ^ 2)) ^ (1 / 2)
'Cells(Cells(Rows.Count, 3).End(xlUp)(2).Row, 3).Value = X & " | " & Y
If i = Cells(Rows.Count, 1).End(xlUp).Row Then Cpt = Cpt + 1: i = Cpt
Next
End Sub |
Partager