Sub reisafstand()
Dim r As Long
Dim PauseTime, Start
Application.ScreenUpdating = False
For r = 2 To 32500 'rijen
If Cells(r, 1) <> "" Then
Worksheets("blad1").Cells(2, 2) = Worksheets("blad2").Cells(r, 1)
Worksheets("blad1").Cells(4, 2) = Worksheets("blad2").Cells(r, 2)
Worksheets("blad1").Range("F26").QueryTable.Refresh BackgroundQuery:=False
Application.Wait (Now + TimeValue("0:00:01")) ' Tijdsduur instellen.
Worksheets("blad2").Cells(r, 3) = Worksheets("blad1").Cells(32, 6)
Worksheets("blad2").Cells(r, 4) = Worksheets("blad1").Cells(33, 6)
Worksheets("blad2").Cells(r, 5) = Worksheets("blad1").Cells(34, 6)
Worksheets("blad2").Cells(r, 6) = Worksheets("blad1").Cells(35, 6)
Worksheets("blad2").Cells(r, 7) = Worksheets("blad1").Cells(36, 6)
Worksheets("blad2").Cells(r, 8) = Worksheets("blad1").Cells(37, 6)
Worksheets("blad2").Cells(r, 9) = Worksheets("blad1").Cells(38, 6)
Worksheets("blad2").Cells(r, 10) = Worksheets("blad1").Cells(39, 6)
End If
Next r
For r = 2 To 32500 'rijen
If Cells(r, 3) = "Voorgestelde routes" Then
Cells(r, 3).Delete Shift:=xlToLeft
End If
Next r
Cells.Select
Selection.Replace What:="1.", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Selection.Replace What:="2.", Replacement:="", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
[A1].Select
Application.ScreenUpdating = True
End Sub