Advertisement
Guest User

Untitled

a guest
Apr 28th, 2017
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. Sub Tour()
  2. Dim Sol(5) As String
  3. Dim i As Integer
  4. Dim Van As Integer
  5. Dim Naar As Integer
  6. Dim U As Integer
  7. Dim Length As Integer
  8. Dim F As Integer
  9. F = 4 * 3 * 2 * 1
  10. U = 5
  11. Length = 0
  12. For i = 0 To 5
  13. Sol(i) = Cells(i + 3, 11)
  14. Next i
  15. For i = 0 To 4
  16. Van = Sol(i)
  17. Naar = Sol(i + 1)
  18. Length = Length + Cells(Naar + 1, U + Van)
  19. If Range("L3") < Length Then
  20. Range("L3") = Length
  21. End If
  22. Next i
  23. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement